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

0 vote131 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote134 views1 answer
Sql auto_increment syntax
SQL
0 vote117 views1 answer
Java input type sql date
SQL
0 vote166 views1 answer
Get initials name in sql
SQL
0 vote134 views1 answer
How to remove default in mysql
SQL
-3 votes126 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote137 views1 answer
Compress sql file database ubuntu
SQL
1 vote137 views1 answer
Ef core 5.0 usesqlserver not found
SQL
10 votes125 views1 answer
Create table oracle
SQL
28 votes126 views4 answers
Delete database mysql
SQL