Apostrophe

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  February 6, 2009 at 8:25 am

  #199689

  Hi...I was unable to insert the following value becuase of an apostrophe. How to handle apostrophe in SQL?? Please let me know...

  I want to insert the following value into the table :

  Example : Insert into table name

  Values ( President's Day)

  But I am getting the error because of the apostrophe...

  Thanks in advance

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9119

  More actions

  February 6, 2009 at 8:28 am

  #939574

  Couple of things:

  1) When you are inserting string value you need to enclose it in Single Quotes.

  2) If the data has single quotes, then you need to replace them with two single quotes. i.e. test'me ==> test''me

  Thanks

  Vijaya Kadiyala

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers

  
  

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  February 6, 2009 at 8:31 am

  #939578

  Awesome....It worked out....

  Thanks a lot

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9119

  More actions

  February 6, 2009 at 8:33 am

  #939582

  Hi

  I am happy 🙂 to see you got the answer 🙂

  Thanks

  Vijaya Kadiyala

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers

  
  

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  February 6, 2009 at 9:04 am

  #939607

  ...If you are using dynamic SQL, make sure to take care of SQL Injection attacks.

  --Ramesh
  

  ---