how to replace double quotes by single quotes in sql server

Question Posted / ranjeet

2 Answers
13215 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 apply cascading referential integrity in place of triggers?

0 Answers

Explain transaction server auto commit?

0 Answers

What is unique key constraint?

0 Answers

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers

Does sql server 2000 full-text search support clustering?

0 Answers

What is executereader?

0 Answers

Explain how to use linked server?

0 Answers

What are tasks?

3 Answers Wipro,

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers

Tell me extended events in sql server 2008?

0 Answers

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers

For more SQL Server Interview Questions Click Here