hi, i want to add a column to a table during program run time. the name of the column will be input by user into a text box and be used as the name of the column. so the name is a variable and dynamic depending on what is being keyed in. how can i tell the system that the column name is a variable. i tried the following command but a syntax error message popup:

ALTER TABLE ADD COLUMN varname C(20)

thanks