>>What version of VFP?
>>In VFP9 you could use CAST(... AS M)
>
>Borislav - It's ver 9 SP2. This works in my test. Thanks.
>Naomi - The SQL will ultimately be executed by a COM server built into a DLL. The function is included in the DLL. I haven't been able to think of any other way to do it.
>
>Intresting that CAST does not come up as a language command in the HELP index but it does come up with a search. :)

As long as it works :)