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