Re: How do I add a null column to...

CREATE TABLE <TABLENAME> AS SELECT <FIELD LIST> , NULL <COLUMN NAME> FROM ...

So just add a null value with a synonym to the select.

                Rudy

new_user_at_email.msn.com wrote in message ...
>How do I add a null column to...to a create tbl as ... SQL string without
>getting a crap columns suck message through ODBC
>
>Oracle is better than Access 2.0
>
>I love you all
>
>Kevin
>
>
>
Received on Fri May 29 1998 - 07:50:41 CDT