How to have leading zeroes

Question

Using SQL Server 2000

Table1

ID

001
0569
897
....

ID Lenght should be 4, if the lenght is 3 then it should add '0' in front.

How to do this.

Need Query Help

Answer 1

See this link for two methods. Summarized:

SELECT RIGHT('0000' + CAST(ID AS VARCHAR(4)), 4) FROM Table1