Try This..... select replace('"ganesh"','"

how to replace double quotes by single quotes in sql server

Question Posted / soorai ganesh

Answer Posted / soorai ganesh

Try This.....

select replace('"ganesh"','"','''')

Output : 'ganesh'

Is This Answer Correct ?

21 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I find the sql server instance name?

917

New concepts of sql server 2005 use in your project.

2303

How do you create type- insensitive operator?

993

How to find out what is the default collation in a database?

1057

What are data regions?

119

Explain transaction server isolation?

979

What is the difference between join and inner join?

952

Explain what is public role in sql server?

1056

How to modify an existing user defined function?

1031

What is Service Broker in sql server 2012?

969

Explain the concept of recursive stored procedure.

878

How to encrypt data between dialogs?

1030

How to find which stored procedure is currently running in sql server?

924

Explain about builtinadministrator?

985

What are the different types of cursor?

1039