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

10 votes187 views4 answers
Primary key sql
SQL
1 vote181 views3 answers
String to int mysql
SQL
3 votes201 views2 answers
See mysql users ubuntu
SQL
1 vote197 views1 answer
How to check the mysql version mac
SQL
0 vote209 views1 answer
Order child below the parent in mysqli
SQL
2 votes272 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote186 views1 answer
Asp.net core sql server stored procedure
SQL
4 votes217 views2 answers
Oracle unliock account
SQL
0 vote170 views1 answer
Dump only schema
SQL
0 vote192 views1 answer
Drop database using terminal postgres
SQL