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 left outer join in sql server joins?

1107

What is snapshot parameter in ssrs?

155

What is a self join in sql server?

1193

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1076

What are the grouping functions?

974

What is indexed view?

1025

Explain what is lock escalation and what is its purpose?

982

What are the differences between stored procedure and the dynamic sql?

1137

Is sql server free?

974

What security features are available for stored procedure?

1077

What is conditional split?

1141

query processing

2220

List the data types available in mssql?

1102

How to delete existing triggers using "drop trigger"?

1098

What is dknf in normalization form?

1111