>Dear Experts,
>
>I want to execute SQL Server Code from Vfp form.
>
>The Vfp stament is 'Select 0000.00 as Cost, Qty from purchase into cursor cur1'.
>Can anybody help me how to write the same code as a Sql Server statement.
>
>i tried in this way
>Cast(Cost as Decimal(7,2), qty from purchase)
>
>But its giving error, pls help me
>
>Regards
>Abdulla
SELECT CAST(0 as Decimal(7,2)) AS Cost, Qty FROM purchase
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.