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

1 vote286 views1 answer
Mysql monthname
SQL
0 vote316 views1 answer
Mql5 datetime get hour
SQL
1 vote300 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote311 views1 answer
Typeorm raw sql
SQL
0 vote289 views1 answer
Mysql select where field is a value
SQL
0 vote314 views1 answer
Oracle current timestamp insert statement
SQL
0 vote343 views2 answers
Clauses in mysql
SQL
0 vote331 views1 answer
Pgadmin save data greyed out
SQL
0 vote293 views3 answers
Sql all columns
SQL
0 vote304 views1 answer
Sql last time database was accessed
SQL