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