How to get the SQL count represented in three digit number?

Question

I have got a count query which counts the number of records in one column of my table. As it returns an integer value, is it possible to get 3 digit value forcefully like '001' instead of '1'?

Is this possible? How?

FYI I am using SQL Server 2008 R2

http://geekswithblogs.net/nagendraprasad/archive/2009/03/19/formatting-number-to-add-leading-zeros---sql-server.aspx — Alexander, Sep 04 '14 at 08:35

score 0 · Accepted Answer · answered Sep 04 '14 at 08:36

0

SELECT RIGHT('000' + CONVERT(VARCHAR,COUNT(*)),3)
FROM Table

answered Sep 04 '14 at 08:36

Giannis Paraskevopoulos

18,261
1
49
69

How to get the SQL count represented in three digit number?

1 Answers1