replacing single quote from a columns in SQL

HI,

I am assuming that you have data as follows

create table test(name varchar(10))


insert into test values('''Nikhil'''),('''KUNAL'''),('''AKHIL''')

in above case

if you want to remove ' only when you are selecting data. you can do it like

select REPLACE(name,'''','') as Names from test

but if you want to remove ' permanently from the name

use

update test set name=REPLACE(name,'''','')

Assuming this is SQLServer,

update customer
set name = replace(name, char(39), '')

Try it..:)

update TableName set Name='Harish Chanda' where Name like '%Harish Chanda%'