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 is the temp table?

923

Define magic tables in sql server?

1058

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1101

Explain what are partitioned views and distributed partitioned views?

943

Differentiate between ms sql server reporting services vs crystal reports?

905

What is a natural primary key?

1045

how will add additional conditions in sql?

1104

How to optimize stored procedure optimization?

892

How to convert numeric values to integers in ms sql server?

1093

How to change the name of a database user?

960

What is difference between drop truncate and delete?

1094

Can you explain what are commit and rollback in sql?

940

What is the difference between for xml raw and for xml auto?

1031

Is resultset an interface?

967

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1194