SELECT Cast(Cost as Decimal(7,2)), qty from purchase
>
>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
--sb--