How do you replace an ' apostrophe 2

[eyhandle]

my code below doesn't work when i try to replace an apostrophe. what should i do?



Update tablename
set first_name=replace(first_name,' ' ' ,'')


thanks

 

[tlbroadbent]

Here are two methods.

replace(first_name, '''', '')

replace(first_name, char(39), '') If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm