Minor CASE formatting issue
mbray
Posts: 9 Bronze 1
in SQL Prompt
I'm using SQLPrompt 9.0.6.3580. Formatting CASE statements with negative WHEN values doesn't insert a space between WHEN and the value. For example, here's the result of formatted code:
Not a huge issue (the code still works), but a bit annoying.
DECLARE @iv int = -1 SELECT CASE @iv WHEN 1 THEN 'positive' WHEN-1 THEN 'negative' END
Not a huge issue (the code still works), but a bit annoying.
Tagged:
Comments