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...


how to replace double quotes by single quotes in sql server

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 manipulate data from one table to another table ?

0 Answers   MCN Solutions,


How to drop an existing stored procedure in ms sql server?

0 Answers  


how many types of store procedre in sqlserver 2000?

2 Answers   ATI,


How to name query output columns in ms sql server?

0 Answers  


How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  


How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,


What is global temp table?

0 Answers  


Explain Normalization and DE normalization

0 Answers   iNautix,


Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,


How we create SQL Server 2005 Reporting Services ? Give me Sample

0 Answers   HCL,


What is Index Segmentation ?

1 Answers   TCS,


Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  


Categories