>>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.
>
>This works
>
>
>select CAST(coalesce(null,0) as int) as NewColumn
>into #NewTable
>
>insert into #NewTable values (null)
>select * from #NewTable
>
>
>In other words, the trick seems in using COALESCE function.
>
>The idea is from
>
http://stackoverflow.com/questions/5465245/create-a-nullable-column-using-sql-server-select-intoThank you. Very good find.
And how would you do this is VFP case?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham