Re: Wildcards

No docs where you are?

Oracle uses 2 wildcards
% for any number of letters ( like * in DOS and others) _ for single char

so for yours:
select * from EOFGMultiGroupedNo0s1
where LOC_DESC Like 'S__' ( 2 under bars) if it fails test it by using
 where LOC_DESC Like 'S%' and look at the data returned to see if any are only 3 chars long

scott_at_yahoo.com (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__'

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Sep 11 2001 - 15:25:15 CDT