how to search for underscore?

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 Wed Feb 09 2000 - 10:36:58 CST