What are the challenges you face when working across database platforms? Take the survey

Formatting in

JimFJimF Posts: 49 Bronze 3
edited September 19, 2016 3:05AM in SQL Prompt
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.



Sign In or Register to comment.