Page 1 of 1
a
Posted: Fri Mar 15, 2002 5:42 pm
by a_rosenbaum_(Guest)
i EXPORTED A FILE WHERE THE ZIP CODE WAS TREATED AS A NUMERIC AND IT DROPPED THE LEADING ZERO.____I CHANGED IT TO A CHARCHTER FIELD - HOW DO I ADD A LEADING ZERO - TO THOSE ZIP CODES WHICH HAVE ONLY FOUR CHARCHTERS?
=> RE: a
Posted: Sat Mar 16, 2002 3:52 am
by pdempsey
Declare a variable like newcode = "0"+oldcode____You may have to trim or ltrim it depending on how you changed the numeric to a character. You may find that the character field has some left justified blanks, so that would mean "0"+LTRIM(oldcode)____Hope that helps.____Pat Dempsey__