a

[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?

[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__