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

How to modify existing triggers using "alter trigger"?

1017

what is the difference between count(*) and count(1) ?

1084

Why should we go for stored procedures? Why not direct queries?

1096

What is triggers in ms sql server?

1118

Differentiate between SQL and ORACLE joins and write their syntax.

1033

What is join query?

893

Explain what are the database objects? : SQL Server Architecture

1077

What is set nocount on and what is set nocount off?

932

What is store procedure? When do you use?

934

What is mean by candidate key?

1011

How do you send email on SQL Server?

1064

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

995

Explain error and transaction handling in sql server?

1012

What is updatable resultset?

1007

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1029