Select data which has apostophe

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  June 26, 2006 at 12:33 pm

  #91971

  I am trying to fetch data from a table which has apostophe in a one of its char datatype col. It errors out when its fetches for this specific row. is there any easy way of retrieving the data. ANy help will be greatly appreciated

  TIA

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  June 26, 2006 at 12:39 pm

  #645901

  Also to add more onto my previous post lets say i have a col name which has data as xxx'x. now my sql is

   

  select * from tab a

  where name = "xxx'x" heres where i am going wrong. how do i get the row which has data with name as "xxx'x". any solns greatly appreciated. THANKS

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  June 26, 2006 at 1:45 pm

  #645914

  The apostrophe is the escape character for the apostrophy

  select *

  From tab a

  where a.name = 'xxx''x'

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  June 27, 2006 at 1:20 am

  #645983

  Since you are probably talking about variables here:

  DECLARE @TextString varchar(30), @QuoteString varchar(30)

  SELECT @TextString = 'Text String'

   , @QuoteString = 'Andy'+CHAR(39)+'s Quote String'

  SELECT QUOTENAME(@TextString,CHAR(39)) AS TextString

   , QUOTENAME(@QuoteString,CHAR(39)) AS QuoteString

  You can see that QUOTENAME will not affect a string without the embedded 'quote_character' parameter's value

  Andy