Not sure if this is the right forum to post this in, but is there anyway to query an Oracle DB for records where a given field contains a percentage sign at the end?

As in: where field like '%%'

Of course, this doesn't work and I know this exercise is awkward, but I'm working with pretty challenging data.

Alternatively, is there anyway to check that field do not contain an underscore?

As in: where field not like '%_%'

Cheers.

You can always use the INSTR function with the character code to check whether a particular character is in a field.

e.g. Checking for rows where column1 contains % character

SELECT * FROM table
WHERE INSTR(column1,CHR(37)) > 0

or replace to CHR(93) for the underscore - these are the ASCII codes.

I am sure there is another way using an escape character too.

Thank you - this is exactly what I was after. Muchly appreciated!