how to replace double quotes by single quotes in sql server

Question Posted / ranjeet

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

More SQL Server Interview Questions

Can a rule be bound to any column of any data type?

How can you stop stored procedures from recompiling?

Write an SQL query to obtain the 2nd highest salary.

What is indexing and its types?

Differences between logshipping and mirroring

What is database replicaion? What are the different types of replication you can set up in SQL Server?

What are the requirements on sql server network connections?

How to change the name of a database user?

What is application role in sql server database security? : sql server security

what is for foreign key ??

Do you know what is bit data type and whats the information that can be stored inside a bit column?

how to select 5 to 7 rows from a table, which contains 10 rows?

For more SQL Server Interview Questions Click Here