How can we help you today? How can we help you today?

How to format WHERE clause

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
VernRabe
0

Comments

2 comments

  • VernRabe
    Problem solved. Thanks for any effort extended.
    VernRabe
    0
  • Robyn
    Hi, 

    Thanks for your post - I'm sorry we didn't reach you in time but very pleased to hear you solved this one yourself!
    Robyn
    0

Add comment

Please sign in to leave a comment.