SELECT < TableToCheck > IF TYPE("< FieldToCheck >") = "U" *-- field doesn't exist ALTER TABLE < TableToCheck > ADD COLUMN < YourField > C(50) ELSE *-- field exists, check the size IF FSIZE("< FieldToCheck >") <> 50 *-- change size of field ALTER TABLE < TableToCheck > ALTER COLUMN < YourField > C(50) ELSE *-- all is fine ENDIF ENDIFHTH