RE: select strings with '_' in it

select col1 from table where col1 like 'v\_lan' escape '\' ;

> -----Original Message-----
> From: Benny Pei [mailto:bplegend_at_yahoo.com]
>
> I have this data 'v_lan' and also 'vclan'. I would
> like to select 'v_lan' but not 'vclan'. Is it possible
> to do that?
>
> I tried
> set escape on
> select col1 from table where col1 like 'v\_lan'
> /
>
> but it doesn't work.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).