Simple format question...

[Guest_imported]

I want to format a query result to put zeros in front of the numbers, like '10' to '0010'. But the problem is: the field is alfanumeric because the numbers can be hex, so 'A01' must be '0A01'. I've tried to use the to_char function (ORACLE) but it didn't work with the letters.

 

[angiole]

Use the LPAD(expression,length,fill) function instead, ex:

select lpad(5,4,0) from dual

returns

0005

select lpad(5,4,'$') from dual

returns

$$$5

AA 8~)

 

[Guest_imported]

Thanx angiole!

 

[Guest_imported]

Thanx angiole!

 

[Guest_imported]

Thanx angiole!