Sql padd let with zeros

If you want nulls to show as '000' 
It might be an integer -- then you would want

SELECT RIGHT('000'+CAST(field AS VARCHAR(3)),3)

As required by the question this answer only works 
if the length <= 3, if you want something larger you need 
to change the string constant and the two integer constants t
o the width needed. eg '0000' and VARCHAR(4)),4

Source: stackoverflow.com

Similar codes

0 vote121 views1 answer
Sql: extract day text from datetime value
SQL
1 vote116 views2 answers
Drop function in sql
SQL
28 votes120 views4 answers
Delete database mysql
SQL
13 votes130 views2 answers
Sql join
SQL
0 vote110 views1 answer
Dnsmasq.conf location macos
SQL
1 vote126 views1 answer
Postgres convert exisiting column to text
SQL
0 vote144 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote128 views2 answers
Coursera spark sql max count
SQL
0 vote120 views1 answer
Oracle archivelog usage
SQL
0 vote129 views1 answer
Psql no such file or directory
SQL