DECLARE @specificCharacterLength INT = 20;

SELECT
	RIGHT(REPLICATE('0',@specificCharacterLength) + REPLACE(CAST(TotalChecks AS VARCHAR(32)),'.',''),@specificCharacterLength)

SELECT
	RIGHT(REPLICATE('0',9) + REPLACE(CAST(COUNT([check number]) AS VARCHAR(32)),'.',''),9) AS TotalChecks,
	RIGHT(REPLICATE('0',12) + REPLACE(CAST(CAST(SUM([Check Amount]) AS DECIMAL(19,2)) AS VARCHAR(32)),'.',''),12) AS TotalAmount
FROM
	SAccounts
	INNER JOIN Checks
		ON  SAccounts.ID = Checks.[Account ID]
WHERE
	NAME = 'PrimerBank'
	AND Checks.[Check Date] = '2012-08-13'

quote:

---

Originally posted by sunitabeck

You are very welcome :)

At the risk of sounding like an annoying broken record: more often than not, it is simpler and better to do the formatting at the client/presentation/reporting side.

---