Maintain Format CASE statment
Posted: Wed 06 Sep 2017 17:11
When I enter a CASE statement, I press enter at the end of each line to help with 'readability'. Example:
CASE TABLE.A
WHEN '1' THEN 'One'
WHEN '2' THEN 'Two'
ELSE 'UNKNOWN'
END AS `New A`
When I move from the text editor to the query builder, enter a filter in the query builder, when I come back to text editor the statement has been reformatted so all the text is on one line:
CASE TABLE.A WHEN '1' THEN 'One' WHEN '2' THEN 'Two' ELSE 'UNKNOWN' END AS `New A`
How can I maintain my multi-line formatting? What am I missing here?
CASE TABLE.A
WHEN '1' THEN 'One'
WHEN '2' THEN 'Two'
ELSE 'UNKNOWN'
END AS `New A`
When I move from the text editor to the query builder, enter a filter in the query builder, when I come back to text editor the statement has been reformatted so all the text is on one line:
CASE TABLE.A WHEN '1' THEN 'One' WHEN '2' THEN 'Two' ELSE 'UNKNOWN' END AS `New A`
How can I maintain my multi-line formatting? What am I missing here?