Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle wildcard search on alphanumeric fields
'%01%'
Daniel Morgan
Jeff Holakowski wrote:
> 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:08:17 CST