To end up with a cursor having the fields and records you want plus an empty memo field just do a cartesian join between the cursor you have and a on record cursor having only an empty memo field. You can force a cartesian join by doing a full outer join between the two cursors (or tables)
>Thanks, but that's the problem; the originating table does not contain a memo field. It seems to me that I was able to do this. Since the functionality exists to use "M" for memo fields when creating a table, I assumed (hoping) that there was a way in SQL to do the same. Anyone have any other ideas? Regards, Renoir
>
>>If the table you select from contains memo field, you can use something like:
>>
>>sele substr(MemoFiledNAme,100000,1) as blank_memo from...
>>
>>>I'm pretty sure I knew how to do this at one time, but now... All I want to do >is select an empty memo field in a select statement (like doing '' or 000 for >character and numeric. I know that I can use create table, but I really want >to have it in the SQL. It's easy, right? Thanks!