When you are saying "old style" you mean VFP old style or in general old style of SQL select?
>It's old style JOIN and only way to implement CROSS JOIN in VFP.
>
>>Thank you, Sergey. I didn't know you can string two cursors one after the other in FROM clause.
>>
>>>
select MYFIELD1, MYFIELD2, CAST(space(10) AS memo) as MYNEWFLD from MYTABLE
Before VFP9 see
Re: Adding memo field as calculated field Message #
683252
"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