IT Professionals

[PARAMASHIVAN]

Hi

I have SQL table with a customer table in SQL server , having columns (name, lastname)
the last name contains values like (o'corner, o'brian) how would i search for these records iusingT-SQL

Select * from customers
where lastname like 'O'coner%'

it does not work cause of the single quote bewteen O and C... any way round it?

Raiks??