wants sql query

#1

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

#2

On Aug 16, 12:46 pm, sachin shah <sachin28... (AT) gmail (DOT) com> wrote:

Quote:

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 %

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

wants sql query

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

wants sql query - 08-16-2007 , 05:46 AM

Re: wants sql query - 08-16-2007 , 06:48 AM