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,'''','')