How do I Select records with Apostrophe in DATA?

[bmann]

How do I Select records with Apostrophe in DATA.
Example: O'Neil

Here is my code:

select top 5 * from cal.dbo.name where lastname = 'O'NEIL%'

SQL Analyser does not like this code.

I would appreciate anyone's help.

 

[DotNetGnat]

select top 5 * from cal.dbo.name where lastname = 'Replace(O'NEIL,"'","''")%'

-DNG

 

[PHV]

select top 5 * from cal.dbo.name where lastname = 'O''NEIL%'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886