Kevin Herring
Member
when you include case statements in the where clause, the where clause and any additional statements after it all appear on the same line after beautification.
e.g.
will all appear on one line.
I am using version 7.0.0.1050
e.g.
Code:
WHERE
t.description = CASE WHEN p_desc = 'ALL' THEN t.description ELSE p_desc END
AND t.another_column = 'Y'
AND t.different_column = 'Z'
I am using version 7.0.0.1050