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

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1213

What are the difference between “where” and “having” clause in sql server?

1066

What are the default system databases in sql server 2000?

1027

what are constraints? Explain different types of constraints? : Sql server database administration

978

What are the different types of columns types constraints in the sql server?

1077

Does order by actually change the order of the data in the tables or does it just change the output?

1141

What new data source types were added in ssrs 2014?

160

What is a periodical index?

923

What is SubQuery in SQL Server 2008

1017

what is normalization? : Sql server database administration

1095

Explain what is public role in sql server?

1121

How to create an index on an existing table in ms sql server?

979

What is conditional split?

1062

Differentiate between a having clause and a where clause.

962

What is factless fact table? : sql server analysis services, ssas

1023