Re: Inserting a string with an Apostrophe

From: CB (anonymous_at_discussions.microsoft.com)
Date: 04/29/04

  • Next message: Vishal Parkar: "Re: Inserting a string with an Apostrophe" 
    Date: Thu, 29 Apr 2004 14:06:02 -0700

    That worked perfectly - excpet what do i do if the value is a variable and not a constant?

    Ex: VariableName = 'D'mario'
          Insert into NAME (LASTNAME) Values ('VariableName')
    So i do not know exactly where the apostrophe is?

    Thank you so much for your help.

         
         ----- Vishal Parkar wrote: -----
         
           double up the single quote.
         
           Insert into NAME (LASTNAME) Values ('D''Mario')
         
           --
           Vishal Parkar
           vgparkar@yahoo.co.in
         
           "CB" <anonymous@discussions.microsoft.com> wrote in message
         news:2EB35DAE-25A4-4CA2-BE04-AA1FCD64F3BC@microsoft.com...
    > I would like to insert a value with an apostrophe into a character
         field. I keep on getting "commande text not set for command object". Is
         there a character that I can put before and after the string to show that
         the system should take the exact value and not look at the characters as an
         indicator?
    > EX: Insert into NAME (LASTNAME) Values ('D'Mario')
         
         
         

  • Next message: Vishal Parkar: "Re: Inserting a string with an Apostrophe"

    Relevant Pages