T-SQL Syntax Bug

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  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

• mccork

  SSC-Insane

  Points: 22288

  More actions

  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