>Hi Naomi
>
>I have some existing VFP vodes that uses VFP EVALUATE. I gather it will be very diificult or impossible to do such using T-SQL code.
>
>I understand that .NET reflextion does something similar but isn't quite easy to implement.
>
>Appreciate if you could advise
>
>Wishing you a Merry Christmas and a great New Year!
>
>Thanks & Best Regards
Yes, I think it may be better to re-write VFP logic into T-SQL, if possible. If it's some complex functionality, in SQL Server 2005 and up you can create CLR function/sp/ or trigger. I didn't try myself, but we have a project that implemented CLR for getting a Hebrew birthday (in Hebrew calendar).
Happy Season to you as well!
If it's not broken, fix it until it is.
My Blog