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

Formatting of IIF does not respect wrapping setting

atompkinsatompkins Posts: 22 Bronze 2
edited April 22, 2014 5:37AM in SQL Prompt
I would expect an IIF to be able to break at the commas at the very least. After all it is a macro for a CASE statement.

Interestingly it is breaking on arithmetic operators in the THEN and ELSE clauses but not the comparison operator in the boolean expression.

I'd also expect it's closing parenthesis to follow the same rules as other functions. In fact I'd expect it to follow exactly the same formatting rules as any other function.


Sign In or Register to comment.