SQL String padding

Question

I there a way to pad String result in SQL server?

Select str from table_name where...

I want str to return with length of 13 with leading '0'.

For example:

In addition, after padding the result i need to query str 3,4 position.

Is there a way to do all of this in one query?

it's been asked before.....multiple times... http://stackoverflow.com/questions/309165/how-do-i-convert-an-int-to-a-zero-padded-string-in-t-sql — Mitch Wheat, Jan 06 '14 at 10:18
The referenced answer shows implementation in T-SQL, is there an implementation is SQL? — Michael A, Jan 06 '14 at 10:28

cubitouch · Accepted Answer · 2014-01-06T10:35:56.997

0

Try using (T-SQL):

SELECT RIGHT(REPLICATE('0',13)+ '12345',13)

Or (Oracle) :

edited Jan 06 '14 at 10:35

answered Jan 06 '14 at 10:24

cubitouch

1 Answers1