When I try using SQLEXEC(nStatementHandle , "SELECT id,100*0 FROM customer"), to retrieve data from mySql Server into VFP cursor, the 100*0 will tranform into character column.


How to make 100*0 to number column rather then character ?

TIA.