I get the idea behind it for stacked column selection, but for stuff wrapped in parenthesis or inside a function it doesn't make sense to me to format those the same way and also for me, makes it harder to read. FYI I'm talking about the comma following QUARTER in the datepart func.

The more commas in the function the odder it gets to read:

Code:

SELECT CONVERT(VARCHAR(50) ,GETDATE() ,101)

Thu Oct 27, 2016 12:32 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6776

You can setup a separate formatting pattern for things within parenthesis, there is a predefined rule for that labeled as (...). Hope that works for you.

Thu Oct 27, 2016 1:30 pm

Mindflux

Joined: 25 May 2013Posts: 646Country: United States

That seems to do it. What's odd is the default is leading commas, but that snippet still had trailing commas until I changed my format preference for commas itself?