syntax error for select statement

[analytics2006]

i need to select records from a table where a column contains a data like the following.
I am getting a syntax error: "Unclosed quotation mark before the character string '
'." How do i fix my query in order to get this record?


select * from cust
where custname ='Mary M'connell'

thanks

 

[SQLDenis]

select * from cust
where custname ='Mary M''connell'

double the tick

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com
Google Interview Questions

 

[analytics2006]

thanks so much, it worked.