SQLTeam.com | Weblogs | Forums

Replace the single quote in with blank space in sql


#1

Hi all,

I have a table Emp_Details in which there is a column named SpouseName, in which the data consists of a single quote for one row, can any one help me in replacing the single quote with blank space. Below is the query i was trying to execute

Update Emp_Details
set SpouseName=REPLACE(SpouseName,''','')

Thank You


#2

You're just missing a single quote. Try it it like this...

REPLACE(SpouseName, '''', '')