Re: how to search for underscore?

select count(1) from some_table
where lower(some_column) like 'stuff/_%' escape '/';

--
Have a nice day
Michel

Sharkie <sharkie2_at_my-deja.com> a écrit dans le message : 87s53a$ikt$1_at_nnrp1.deja.com...
> How can I search for an underscore? Oracle considers
> underscore as one character, is there a way to escape it?
>
> Ex: my search string is something like: "stuff_below"
> I want to search for everything that starts with "stuff_"
>
> if I try:
> select count(1) from some_table
> where lower(some_column) like 'stuff_%';
>
> this will return everything that starts with "stuff".
>
> Thanks for any help
>
> --
> If the human brain were so simple
> that we could understand it,
> we would be so simple we couldn't.
> -Makes Sense... don't it?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Feb 10 2000 - 02:14:15 CST