how to replace double quotes by single quotes in sql server

Answers were Sorted based on User's Feedback



how to replace double quotes by single quotes in sql server..

Answer / soorai ganesh

Try This.....

select replace('"ganesh"','"','''')

Output : 'ganesh'

Is This Answer Correct ?    21 Yes 1 No

how to replace double quotes by single quotes in sql server..

Answer / vimal

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

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Define right outer join in sql server joins?

0 Answers  


How much space does sql server 2016 take?

0 Answers  


List down some advantages of sql stored procedure?

0 Answers  


what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  


What is bcp? When does it used?

0 Answers  






Is sql server difficult to learn?

0 Answers  


What is a DBMS, query, SQL?

0 Answers   Maveric,


Define Foreign Key?

3 Answers   ADP, College School Exams Tests,


Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,


Explain left outer join and right outer join?

0 Answers  


What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  


What is Lock table in SQL?

0 Answers   Wipro,


Categories