[9.0.176 Pro] - Trailing vs leading comma formatting

[9.0.176 Pro] - Trailing vs leading comma formatting

I've recently switched to leading commas in my formatting rules..

Though I think there may be an unintended (and weird looking) consequence to this.

Trailing:

	Code:
	SELECT 'Q' + CAST(DATEPART(QUARTER, GETDATE()) AS VARCHAR(1)) AS Quarter

Leading:

	Code:
	SELECT 'Q' + CAST(DATEPART(QUARTER ,GETDATE()) AS VARCHAR(1)) AS Quarter

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)

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.

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?