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