Post reply

Inserting Value problem

  • July 11, 2004 at 9:42 pm

    #109088

    Hi,

    How can I insert the following variable using

    Insert Into ...

    Values....

    the value is --> 2','3','4 <--- Exactly as it is here!! I just cant figure out a way to get it to recognise it as a single variable. Many thanks

  • July 11, 2004 at 10:17 pm

    #514230

    1 way is to SET QUOTED_IDENTIFIER OFF

    and then you can use double quotes for string variables.

    Example; "2','3','4"

    Kindest Regards,

  • July 11, 2004 at 10:20 pm

    #514231

    Thank you, that worked!

  • July 12, 2004 at 11:08 pm

    #514331

    One more way is to replace all single instance of "'" with "''" using replace function.

  • July 13, 2004 at 2:47 pm

    #514464

    You can also insert:

    '2'',''3'',''4'

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply