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

61 votes571 views6 answers
Mysql add column
SQL
1 vote342 views1 answer
Sql to mongodb query converter
SQL
0 vote371 views2 answers
Py sqlite if entry exists
SQL
0 vote368 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote325 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote332 views1 answer
Firebase bigquery cloud message
SQL
2 votes364 views1 answer
Drop all database tables oracle sql developer
SQL
2 votes332 views1 answer
Mysql list users on ubuntu
SQL
6 votes361 views1 answer
Oracle list primary key
SQL
0 vote356 views1 answer
Monthly Birthday SQL Query
SQL