Re: Inserting a string with an Apostrophe

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 04/29/04 

Date: Fri, 30 Apr 2004 02:39:45 +0530

  change it in variable assignment itself.

  Ex:
  declare @VariableName varchar(50)
  set @VariableName = 'D''mario'

  --
  Vishal Parkar
  vgparkar@yahoo.co.in