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

What are the advantages of user-defined functions over stored procedures in sql server?

How to connect of datebase with sql express.?

What is difference between materialized view and view?

what operator performs pattern matching?

Explain data warehousing in sql server?

What is a derived table?

Differentiate between SQL and ORACLE joins and write their syntax.

How to swap the data of two columns in a table. both the columns containing varchar values.

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

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

What is dknf in normalization form?

How to list all tables having unique constraints in any of the columns in a database.

For more SQL Server Interview Questions Click Here