Billy

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE Customer     && Open customer table

gnFieldcount = AFIELDS(gaMyArray)  && Create array
CLEAR
FOR nCount = 1 TO gnFieldcount 
   ? gaMyArray(nCount,1)  && Display field names
ENDFOR

This will list the field, and you can check if the field you r looking is present if not add the field

HTH

>Hello all,
>
>I need code that will do the following:
>
>1. Check to see if a column (field) exists in a table.
> 1a. If the column does exist, then exit.
> 1b. If the column does NOT exist, then add the column to the table.
>
>
>Any help will be appreciated.
>Thanks,
>Billy