>I have a large DB that and 2 of its fields are labled zip and zip2. The
>zip field contains the first 3 #'s of the zip and the zip2 column
>contains the last 2 #'s. How can I combine the two fields into one that
>has a 5 number zip?
add a field (total_zip?) defined as char 5.
if the two fields are defined as Char 3 and Char 2,
replace total_zip with zip + zip2
if the two fields are defined as numeric 3,0 and numeric 2,0
replace total_zip with right('000'+trim(str(zip)),3) + right('00'+trim(str(zip2)),2).