Theo,

Does MySQL have a cast() type function? If so I like to use it to make sure I get the data type I want.

select cast(0 as int) as fld1, ....

>When we do a :
>"select 0 as fld1, aa from table1 into cursor table2",
> in vfp and in MsSql (via sqlexec) the resulting fld1 field is numeric.
>
>MySQL returns the fld1 as a character field. It does so even if we use the: "select cast(0 as unsigned) as fld1, aa from table1 into cursor table2".
>
>Could odbc be doing some kind of conversion? I 've used the options = 262657 in the sqlconnect string but I don't see any difference.
>
>Has anyone come across this before?