>How do you do it?
>
>field 1: char(3)
>field 2: char(3)
>
>want to combine them into
>new field 3 char(6): field 1 + field 2
>
>ex: field 1: 201, field 2: 230, field 3: 201230
ALTER TABLE MyTable ADD COLUMN FIELD3 C(6)
USE MyTable
REPLACE ALL Field3 WITH Field1 + Field2
>
>thanks,
>ryan