I figured out one way, kind of kludgy, but it works.

SET SAFETY OFF
OPEN DATABASE kludge

ALTER TABLE foo ADD COLUMN temp C(20) NULL
ALTER TABLE foo DROP COLUMN temp
ADD TABLE foo

This method gives no warning as the conversion happens during the ALTER TABLE. Anyone else have any cleaner ideas?

Marty