Create 1000 Function W/ Leading 0's

Question

Good Morning DBA's, I need a function to pulls an int DocumentID column and returns the lowest thousand int. The limitation is our result must have 8 chars and the leading characters need to be 0's.

Example 1: 1234 (int contained in DocumentID column) Result: 00001000 (generated by function in result set)
Example 2: 1152534 Result: 01152000

Result Set...

DocumentID Function 

1234       00001000 
1152534    01152000

score 0 · Answer 1 · answered Sep 10 '13 at 15:18

0

Here is the basic structure. The exact commands may vary depending on the RDBMS.

right('00000000'||cast(DocumentID as varchar(8)),8)

answered Sep 10 '13 at 15:18

Declan_K

6,726
2
19
30

Luis LL · Accepted Answer · 2013-09-10T15:41:08.360

0

this is for SQL Server (based on @Declan_K's answer)

SELECT RIGHT('0000' + CONVERT(VARCHAR(5), DocumentID  /1000) , 5)+ '000'

edited Sep 10 '13 at 15:41

answered Sep 10 '13 at 15:22

Luis LL

2,912
2
19
21

Create 1000 Function W/ Leading 0's

2 Answers2