Post reply

T-SQL Syntax Bug

  • August 1, 2003 at 10:24 am

    #83949

    I know I typed this wrong during testing but I didn't get an error.

    I was consolidating a stack of IF .. OR IF .. into a IN clause

    IN ('4897','4898','4899','4896','4424','4425','4426','4434')

    Works Just fine

    IN ('4897' '4898' '4899' '4896' '4424' '4425' '4426' '4434')

    Produces a Syntax error (there is a space between each entry)

    IN ('4897''4898''4899''4896''4424''4425''4426''4434')

    Runs just fine, but only uses the first ('4897') entry. No space between each entry.

    Just something to watch out for.

    KlK, MCSE


    KlK

  • August 2, 2003 at 2:02 am

    #468304

    Kevin,

    The last example won't throw an error because it's a valid SQL string. The lack of intervening spaces means that the doubled quotes are interpreted as single quotes.

    If you run:

     

    select '4897''4898''4899''4896''4424''4425''4426''4434'

    You get:

     

    4897'4898'4899'4896'4424'4425'4426'4434

    Cheers,

    - Mark


    Cheers,
    - Mark

Viewing 2 posts - 1 through 1 (of 1 total)

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