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

2 votes152 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote145 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote148 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
2 votes126 views1 answer
Wait delay in sql server
SQL
0 vote134 views1 answer
Insert or update sql query
SQL
0 vote136 views1 answer
Sql server check whether column has same equal values
SQL
15 votes144 views2 answers
Select Options
SQL
4 votes131 views3 answers
Create database in mySQL
SQL
13 votes153 views2 answers
Sql join 3 tables
SQL
0 vote129 views1 answer
Deny select insert update delete sql
SQL