SQL for records that contain a percentage sign
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 '%_%'