If I format the following
Select *
From Person.Address As a
Where a.AddressID In ( - 1, -2, -3 )
You will notice that there is a space between the negative sign and the 1 (-[space]1), but the rest of the values in the In clause are formatted correctly. Even if I manually remove the extra space, redoing the SQL formatting always puts the space back in for the first value.
Thanks,
Jim
Thanks,
Jim