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