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 vote219 views1 answer
Alter domain sql
SQL
1 vote197 views1 answer
Postgres power
SQL
3 votes191 views2 answers
Sql get month name
SQL
0 vote192 views1 answer
Flexible search query delete table
SQL
0 vote239 views1 answer
How to check foreign key constraint in sql
SQL
4 votes191 views2 answers
Tsql utf to local time
SQL
3 votes195 views2 answers
Oracle apex charging debug
SQL
2 votes198 views1 answer
Apex execute batch job
SQL
0 vote226 views1 answer
Postgresql alter table sequence
SQL
1 vote191 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL