Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle wildcard search on alphanumeric fields
Hi,
I am trying to get a list of values in an alphanumeric field and I'm having trouble using the '%' and '_' characters. I would like to get a listing where all values in "xxx01xx" are displayed (x being variable). I've used "where location like '___01__' but this returns no rows. Any suggestions?
Thanks Received on Thu Feb 28 2002 - 16:07:32 CST