Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have zipcodes like 04106 (US) and v3w (Canada). When I code:
sql
select zipcode
from table;
It's cutting off leading 0. For example, 04106 becomes 4106. How can I fix this problem?
I have tried num(zipcode), but it's going to remove zipcodes like v3w.
Thanks in advance!
Hi,
try this:
table:
load
text(zipcode) as zipcode;
sql
select zipcode
from table;
Hi,
try this:
table:
load
text(zipcode) as zipcode;
sql
select zipcode
from table;
Hi Wanyun,
I guess you can handle the field as text, instead of num. That way you will have both values with no alterations.
Carlos M