You have to enclose any name that is invalid name in SQL Server into square brackets. Check BOL for definition of valid/invalid names.

>
>I have a column/field named "OPTION". I have noticed that in SQL Server this name is enclosed in square brackets "[]". Therefore I presume that this name is reserved. Therefore the column named "OPTION" is ok.
>
>But the problem I have is when I created a SQL Command and pass it to the SQL Server via SPT, I get error "near keyword [option]".
>
>How can I include name OPTION in the SQL Select so that SQL Server will allow it? Here is a segment of the SQL Select I have:
>
>

>... ISNULL( mytable.option, CAST('' as CHAR(8))) as OPTION
>