Select Replace('""','""',Char(39)+C

how to replace double quotes by single quotes in sql server

Question Posted / vimal

Answer Posted / vimal

Select Replace('""','""',Char(39)+Char(39))

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I port a number to sql server?

496

what is a self join? : Sql server database administration

520

Are all views updatable ?

718

What is intellisense?

572

What do you understand by the denormalisation?

542

How do you manipulate data?

481

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

522

How many database files are there in sql server 2000?what are they?

572

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

498

How to remove duplicate rows from table except one?

564

Explain in brief about Microsoft SQL server?

535

Explain alternate key, candidate key and composite key in sql server?

513

What are the instances when triggers are appropriate?

511

Can group functions be used in the order by clause in ms sql server?

580

Explain something about security and SQL Azure?