Keeping leading zero when convert integer to char

chulgyu100 · #1 (**permalink**) 11-19-08, 06:34

Hello,

i want to keep leading zero when converting integer to char.
for example, integer 6 is converted '00006'.

any comment will be appreciated.

JAYANTA_DATTA · #2 (**permalink**) 11-19-08, 07:03

There must be other easier ways to do the same. You can try this as well:

select rtrim(char(decimal(col1,6))) from test.xxx2 with ur

Where COL1 is of data-type INTEGER.

umayer · #3 (**permalink**) 11-19-08, 07:07

TRY:

DIGITS( value )

eg: DIGITS ( 6 ) returns '0000000006' , if 6 is an INTEGER
and it returns '00006' if 6 is a SMALLINT

chulgyu100 · #4 (**permalink**) 11-19-08, 07:27

Thanks so much for reply.

Internet Services

Web Development

Digital Marketing

Consumer Tech