>>>
>>>... ISNULL( mytable.option, CAST('' as CHAR(8))) as OPTION
>>>
>>>
>>>Thank you in advance for any help.
>>
>>You can try
>>
>> ISNULL( mytable.option, CAST('' as CHAR(8))) as "OPTION" or try [] if the first option would not work.
>
>I tried both approaches and neither one work. Thank you.
First try to create this statement in SQL Server, once you be able to make it work there, it should work in VFP as well.
If it's not broken, fix it until it is.
My Blog