Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Explain view in sql server?

0 Answers  


Different Types of Functions ?

2 Answers   Satyam,


Explain the different types of backups available in sql server? : sql server database administration

0 Answers  


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  


CREATE a table from another table

2 Answers  






What is the command to change the recovery model?

0 Answers  


What is the use of custom fields in report?

0 Answers  


I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,


How to list all user defined functions in the current database?

0 Answers  


You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  


Explain transaction server explicit transaction?

0 Answers  


wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,






Categories