Trouble with Update Statement For Records with Apostrophe

[bmann]

Hello. I am having trouble with the Update SQL statement in sql analyzer. I am trying to change the lastname O'NEIL to
ONEIL.

Let me Explain:

Field Data

Last O'NEIL


I want to change Data to take the apostrophe from name:

Field Data

Last ONEIL



Here is my code:

Update cal.dbo.name
set last = Replace(last , "'", "")
where last LIKE 'O''NEIL%'


This is the error I get.

Server: Msg 1038, Level 15, State 3, Line 2
Cannot use empty object or column names. Use a single space if necessary.

 

[PHV]

Why not post in a SQL Server forum ?

 

[bmann]

I guess I thought I was in the sql server forum. Sorry.