Re: Wildcards

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