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

BitPagg Meios de Pagamento December 14, 2017 20:28

2 comments

Please sign in to leave a comment.

How can we help you today?