how to replace double quotes by single quotes in sql server

Question Posted / ranjeet

2 Answers
13209 Views
CAC, I also Faced
E-Mail Answers

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

how to get the rowid/rownumbes of a table in sqlserver

7 Answers IBM,

What happens if null values are involved in string operations?

0 Answers

What is mean by candidate key?

0 Answers

Are resultset updatable?

0 Answers

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers

Does index slows down insert statements?

0 Answers

How does using a separate hard drive for several database objects improves performance right away?

0 Answers

How can you find out how many rows returned in a cursor?

0 Answers

What is database architecture? : SQL Server Architecture

0 Answers

What are different types of raid levels?

0 Answers

What does this statement do @@rowcount?

0 Answers

What is the difference between local and global temporary tables?

0 Answers

For more SQL Server Interview Questions Click Here