How do you insert a row with a single quote '

• soumil

  Mr or Mrs. 500

  Points: 508

  More actions

  April 29, 2003 at 10:25 am

  #101455

  Hi

  How do you insert a row into a table where one of the column has single quote ' as a part of the columns data.

  For eg.

  Create table a1 (a varchar(3000))

  insert into a1 values ('This is Soumil's laptop')

  How do we go about insert this row which obviously has a single quote which marks the end of character string?

  Thanks for your help.

  -Soumil

• paulhumphris

  Hall of Fame

  Points: 3496

  More actions

  April 29, 2003 at 10:32 am

  #455713

  You need to escape the single quote with another single quote like this.

  insert into a1 values('This is Soumil''s laptop')

• bilko73

  Old Hand

  Points: 377

  More actions

  April 29, 2003 at 12:34 pm

  #455724

  this works:

  SET QUOTED_IDENTIFIER OFF

  GO

  Create table #a1 (a varchar(3000))

  insert into #a1 values ("This is Soumil's laptop")

  select * from #a1