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

5 votes307 views1 answer
Mysql add user with all privileges
SQL
15 votes513 views2 answers
How to sort names in alphabetical order in sql
SQL
9 votes295 views5 answers
Sql delete duplicate rows but keep one
SQL
5 votes272 views1 answer
How to use rank function in sql
SQL
1 vote278 views1 answer
Postgres install unaccent extension
SQL
0 vote283 views2 answers
Mysql unique two columns
SQL
2 votes301 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote338 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
42 votes343 views6 answers
Install beautifulsoup
SQL
0 vote311 views1 answer
Add user mysql wordpress
SQL