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

Parentheses lost aligment in case/when clauses

Hi.
I'm trying to format a code as the sample bellow:
select	case 1
			when 1 then
				1
			when 2 then
				(2)
			when 3 then
				3
			when 4 then
				4
			when 5 then
				5
			when 6 then
				6
		end;
So have a complex statement that requires parenthesis to be coded.

When SQL Prompts reformats my code, this happens:
select	case 1
			when 1 then
				1
			when 2 then
	(2)
			when 3 then
				3
			when 4 then
				4
			when 5 then
				5
			when 6 then
				6
		end;

Any idea?

Best regards,

Ésio

Answers

Sign In or Register to comment.