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 vote164 views1 answer
Create table with float datatype in sql server
SQL
1 vote185 views1 answer
Opensuse restart MySQL
SQL
37 votes196 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote191 views1 answer
Set Mamp mysql globally
SQL
0 vote167 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote183 views1 answer
Pl sql search in all packages
SQL
0 vote153 views1 answer
Mysql url
SQL
0 vote169 views1 answer
Sql server roles and users
SQL
0 vote180 views1 answer
Finding leap year in sql
SQL
0 vote155 views1 answer
Create table database in psql
SQL