467,154 Members | 901 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

how do you add a zero to the left of an integer

hi all

say i have:
declare var1 CHAR(06) default '012345';

if i cast it to integer i get 12345 only
how do i cast it to integer yet maintain the leading zero?

Jul 12 '07 #1
  • viewed: 1098

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Margaret MacDonald | last post: by
8 posts views Thread by Steve | last post: by
33 posts views Thread by gk245 | last post: by
46 posts views Thread by lovecreatesbea...@gmail.com | last post: by
10 posts views Thread by tshad | last post: by
1 post views Thread by ags5406 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.