how to replace double quotes by single quotes in sql server

Answer Posted / soorai ganesh

Try This.....

select replace('"ganesh"','"','''')

Output : 'ganesh'

Is This Answer Correct ?    21 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

590


Will sql server 2005 allow you to reduce the size of a column?

554


How to store and query spatial data?

562


In what three ways is the return statement used in a stored procedure?

517


how many type of indexing in database?

583






Explain what are various ways to enhance the ssrs report?

572


What is the correct order of the logical query processing phases?

527


What's the information that can be stored inside a bit column?

544


What are triggers? How do you invoke a trigger on demand?

751


Why Master database is required?

607


Explain about Joins?

610


How many non clustered indexes there can be on table ?

511


Explain about Normalization?

571


What Is Rdbms?

675


Write a query for primary key constraint with identity key word?

580