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 advantages of having an index on the sql server?

682

Why should you use or avoid select * statements?

733

What types of replication are supported in sql server?

735

What are the limitations/drawbacks or ssrs 2008 r2?

105

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

803

What are different types of raid configurations? : SQL Server Architecture

730

Can you explain what is sql server english query?

726

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1805

What is the purpose of object explorer and its features? : sql server management studio

807

Do you know the capabilities of cursors?

768

What according to you is the difference between mysql and sql server performance?

766

How many types of functions are there in sql server?

604

What is lock escalation and what is its purpose?

713

role of sql sever 2005 in database rather than any other database

1719

How do I view a script in sql server?

723