> I have the following DATABASE.
>
> CREATE TABLE codestatus (
> id int primary key,
> code int,
> status char
> );
>
> code is an int number made at least of 6 numbers.
> (range from 0 up to 999999)
>
> If i do :
>
> select * from codestatus;
>
> I GET:
>
> id|code|status
> --+------+------
> 1| 44111|N
> 2| 123|S
>
> BUT I WOULD LIKE TO GET
>
> id|code|status
> --+------+------
> 1|044111|N
> 2|000123|S
>
> How could I fix the prbolem and get the values as I ned them
> out of the
> select ?
>
> thanks in advance
>
> Alex
>
Try
select id, lpad(code, 6, '0'), status
from codestatus
John