>Hi
>
>What is SQL-Server's procedural language like? Is it any good to use as a middle-tier?
>
>This will be for a complex system where the rules are pretty heavy.
>
>Thanks
>Kev
Fast and short answer: in this case - no. SQL Server procedural language is actually Transact SQL. If you have many calculations and non linear and/or relational rules to follow, better is to use full-featured data manipulation language like this one in VFP.
On the other side, you may choose to code some of the logic as stored procedures, triggers, etc. in the SQL server database, but keep in mind that this has serve CPU overhead. If you use client processing with VFP you will have network traffic overhead, so that you should consider this trade-off.
HTH
Zlatin Zlatev,
MCSD (VS6)Make solutions, not programs!