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

7 votes205 views6 answers
Mysql group concat
SQL
0 vote174 views1 answer
Oracle date summer time
SQL
1 vote192 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote183 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote133 views1 answer
Update row in sqlite python
SQL
0 vote190 views1 answer
Execut sql python
SQL
12 votes170 views1 answer
Env var for setting password for root user mysql docker hub
SQL
15 votes188 views4 answers
Mysql export database command line
SQL
6 votes165 views1 answer
Phpmyadmin reset root password
SQL
0 vote194 views1 answer
Sql server set complex constraints
SQL