Hi All,

I've got a cold and can't think straight, so while I'm working on this, I thought I'd post it here as a quick and easy puzzle (hopefully)

I need to output a column, with a leading zero.

Column is PURN NUMBER(10).

I get this:-

select PURN from PERSON
where rownum < 3;

PURN
---------
400000001
400000002

col purn for 0999999999

/

PURN
-----------
0400000001
0400000002

See, it puts a blank before the zero for some reason. Can this be done without resorting to single row functions ?