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 vote195 views1 answer
How to use update trigger in sql
SQL
1 vote217 views1 answer
Retrieve meaning
SQL
0 vote211 views1 answer
Mysql get last 2 month data
SQL
0 vote193 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
9 votes212 views4 answers
Postgresql export database
SQL
1 vote205 views2 answers
Sql server backup table
SQL
12 votes246 views6 answers
How to install sqlite3 in python
SQL
0 vote184 views1 answer
Count the table indatabase
SQL
1 vote625 views1 answer
How to lock table in mysql
SQL
0 vote193 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL