Re: How to write a SQL statement pull out string data contain '%'

select * from
where instr(field_name,'%') > 0

"Helen Jian" <helenjian_at_attcanada.ca> wrote in message news:Uo9W5.3665$tj4.10296_at_tor-nn1.netcom.ca...
> Hi All,
>
> For example, one table has a varchar2(20) column, there are three rows in
> this table:
>
> 1 'Mon%day'
> 2 'Tuesday'
> 3 'Wedne%sday'
>
> Anyone know how to write a SELECT statement pull out row 1 and 3 which
> contain '%' character?
>
> Thanks in advance
> Helen
>
>
Received on Sat Dec 02 2000 - 15:47:44 CST