How is SQL Prompt helping your team? Share your experience.

How to format WHERE clause

VernRabeVernRabe Sherwood, OR, USAPosts: 6 New member
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
Tagged:

Answers

Sign In or Register to comment.