Without using an Alter Table after the select I don't think it can be done. Set null has no effect. Of course you can use Create cursor, but that really doesn't fit with what you are trying to accomplish here. Even if you attenpt to place the nulls in as values for your select statement you will run into a problem with SQL determining the data type of your fields... So, there you have it.<g>
>I am trying to use a select statement to create an empty cursor into which I can write data, like:
>
>Select blah, blahh, blahhh FROM blaaaah INTO CURSOR myCursor READWRITE
>
>Unfortunately, I need the fields in the resulting cursor to accept nulls, which they do not. How can I make these fields accept nulls?
>
>TIA
>
>Russ