How to format WHERE clause
VernRabe
Posts: 6 New member
in SQL Prompt
Using SSMS 18.1 and SQL Prompt 9.5.8.10521, I can't seem to figure out how to format a WHERE clause as I'd like. Any help would be appreciated. What I'd like is something like...
WHERE A.Col1 = 5
AND B.Col1 IS NULL
AND C.Col1 <> 0
All attempts result in all comparisons on the same line, e.g.,
WHERE A.Col1 = 5 AND B.Col1 IS NULL AND C.Col1 <> 0
Thanks
WHERE A.Col1 = 5
AND B.Col1 IS NULL
AND C.Col1 <> 0
All attempts result in all comparisons on the same line, e.g.,
WHERE A.Col1 = 5 AND B.Col1 IS NULL AND C.Col1 <> 0
Thanks
Tagged:
Answers
Thanks for your post - I'm sorry we didn't reach you in time but very pleased to hear you solved this one yourself!