>Hi,
>
>What is the syntax of adding a placeholder-column to a cursor that would allow NULLs?
>
>Here is the code:
>
>

>select MYTABLE.*, CAST(0 AS INT) AS MyField1 FROM MYTABLE
>

>
>I need to make sure that the column MyField1 would accept NULLs. How do I do it? TIA.

to get a nullable integer field,
the min code on SQL SERVER is:

-- fill with null value
SELECT NULL AS IntField
-- fill with not null value
SELECT CAST(3 AS INT) AS IntField