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 vote273 views1 answer
List all permissions on a table in postgres
SQL
0 vote360 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote246 views1 answer
Sql where time stamp is in between
SQL
3 votes263 views1 answer
Select nextval from sequence sql
SQL
0 vote247 views1 answer
Time in sql server
SQL
0 vote290 views2 answers
Amazon linux postgresql client
SQL
1 vote275 views3 answers
Connect to mysql c# connection string C#
SQL
2 votes257 views1 answer
Oracle cpu per session
SQL
1 vote258 views1 answer
Oracle explain plan
SQL
0 vote246 views1 answer
Selects all the columns from the sailors table
SQL