Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Wildcards
On Tue, 11 Sep 2001 20:18:57 GMT, Nick Taylor
<ntwysiwyg_at_dataskill.co.uk> wrote:
>Scott wrote:
>>
>> Is there a caracter Oracle regonizes as a character wildcard?
>>
>> I am looking for results that are only 3 characters long and begin
>> with "S". The SQL stmt might looks something like below, but I do not
>> konw because this is not returing any results (failing).
>>
>> select * from EOFGMultiGroupedNo0s1
>> where LOC_DESC Like 'S__'
>
>AFAIK you have the command right so you need to look elsewhere for your
>problem. Does like 'S%' find all beginning with S?? Maybe you should try
>checking the length of you strings in case they are padded with spaces?
>
>Nick
>--
>Nick Taylor
>Say No to Spammers - What You See Isn't What You Get to Email Me
'S%' did find all beginning with S. The field was padded with spaces after the 1st 3 characters.
Thank You!!
Scott Buerkley
Received on Tue Sep 11 2001 - 15:52:09 CDT