Can you show the syntax you have used? Error message seems to point in that
direction.

> -----Original Message-----
> From: Vikram Somanathan [SMTP:[Email Address Removed] Sent: Tuesday, May 28, 2002 9:05 AM
> To: '[Email Address Removed] Subject: default value
>
> hi gurus,
>
> i am trying to change a field to have a default value of 'N' , but i keep
> getting this error
>
> 'TABLE1' table
> - Unable to create table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The name 'N' is
> not permitted in this context. Only constants, expressions, or variables
> allowed here. Column names are not permitted.
>
> any clues????
>
> Regards,
> Vikram Somanathan
> Software Engineer
> TSG - Solutions Unit
>
> "Work for Excellence Not for Perfection"
>
MS Sql Server LazyDBA home page