>Is it possible to programmatically add a field to an existing table? If so, how?
>
>Thanks in advance for your help,
>Russell
ALTER TABLE MyTable;
ADD COLUMN MyNumColumn N(8,2);
ADD COLUMN MyDateColumn D
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)