Apostrophe Handling in Dynamic sql

• REJI P R

  SSC Veteran

  Points: 295

  More actions

  July 9, 2008 at 8:51 am

  #381577

  I am in a need to create a dynamic sql . But in this script column values contains apostrophes ( ' -: Eg : Reji's ) . I can create the query by temporarly replacing the character . but it will take more time . Without using replace option how to create the sql .

  Thanks in Advance

  Regards,

  Reji P R

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  July 9, 2008 at 8:56 am

  #840225

  Either replace the (') with doubles ('')

  or use (" ")

  set QUOTED_IDENTIFIER OFF

  select "Reji's"

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  July 9, 2008 at 8:56 am

  #840226

  HI ,

  I guess the first question is, do you have to use dynamic SQL and why?

  Secondly why do you not want to use the REPLACE function?

  Thanks

  Chris

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life