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 does sql server mean?

1053

How to create median function?

164

Write down the syntax and an example for create, rename and delete index?

980

what are database files and filegroups? : Sql server database administration

943

What is the default server name for sql server?

1161

Can truncate be rolled back?

935

How to call a function from a stored procedure in SQL Server ?

1025

What is the xml datatype?

1053

How to recreate an existing index in ms sql server?

1047

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1923

what is a mixed extent? : Sql server administration

1096

What does select 1 mean?

924

Explain transaction isolation levels in sql server?

1110

What is scheduled job and how to create it?

982

When would you use the stored procedures or functions?

998