Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Post New Answer

More SQL Server Interview Questions

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

explain extended properties

0 Answers  

What are the restraints imposed on the table design by a merge replication?

0 Answers  

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

Please explain go command in sql server?

0 Answers  

What are the advantages of passing name-value pairs as parameters?

0 Answers  

What are synonyms?

0 Answers  

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

Can you index views?

0 Answers  

What are the approximate numeric data types?

0 Answers  

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

what are the limitations of parameters in a storedprocedure

1 Answers  

For more SQL Server Interview Questions Click Here
Categories