trying to stop indention of AND/OR statements

rtowne@smarsh.com

I can't figure out either through the layout in SQL Prompt or SQL Refactor how to stop indention of AND/OR Statements:

What is showing:

select  *
from    dbo.someTable am
where   someColumn1 = 1
		and someColumn2 = 0

What I want to show:

select  *
from    dbo.someTable am
where   someColumn1 = 1
and		someColumn2 = 0

Thank you for any suggestions ahead of time.

Robert

Ben Pinchen

Unfortunately, currently, there isn't a way to have SQL Prompt or SQL Refactor lay the code out as you require.

However, I have added this as a feature suggestion so that the developers will consider implementing this when they work on a future version of the software.

rtowne@smarsh.com

OK,
thanks for letting me know all of that - nice product + support.