SQLTeam.com | Weblogs | Forums

Replace Single Quote 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

try

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