Thanks

>It cannot be done directly in VFP7 but it can be done. See Re: How to create empty memo in SQL Select Message #996758
>
>>Thanks Sergey. That's what I did. I thought there could be another way. As for the other I probably have them all. I mean logical, strings, numeric. And I hope to be able to make that move to VFP9 soon. I already tested some things in my app in VFP9 and it looks ok.
>>
>>Is it possible to add memo? This one is just out of curiosity. Not that I need it and I guess that string could be used instead.
>>
>>>Use zeros to tell VFP what sizes of the field you want or upgrade to VFP9 and use CAST() function

>>>select Amount1, amount2, 000000.00 AS ResultComputation
>>>

>>>What other types are interested in?