Select Replace('""','""',Char(39)+C

how to replace double quotes by single quotes in sql server

Question Posted / vimal

Answer Posted / vimal

Select Replace('""','""',Char(39)+Char(39))

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between truncate and delete commands?

571

Explain concepts of analysis services?

517

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

605

What is sub query and its properties?

549

How to list all schemas in a database?

582

Why we use trigger in sql server with example?

514

Where to find ntwdblib.dll version 2000.80.194.0?

560

Do you know what are the properties of the relational tables?

579

What is the purpose of linked server configuration in sql server?

561

How extra digits are handled with numeric data type literals?

529

How to link tables in sql server?

483

How to execute stored procedure and set temp table in sql server?

560

What is a trigger? Why we need it?

537

What is data compression?

550

Can we update data in a view?

607