Posted by PDreyer on 08/16/07 11:48

On Aug 16, 12:46 pm, sachin shah <sachin28...@gmail.com> wrote:
> hi
>
> my table having record
>
> cust_name
> sachin's
> vishal's
> sumeet
> rajesh
>
> i want the query which having ' (single quote)character....
>
> result
> sachin's
> vishal's

select cust_name result from mytable
where cust_name like '%''%' -- Note 2 single quotes between % and %

[Back to original message]