wants sql query

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

Re: wants sql query

On Aug 16, 12:46 pm, sachin shah 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 %