I'm using VFP as a front end to an access MDB.
Using an access query I can...
select IIF(gender=1,'M','F') as sex and it works fine, thru ODBC the same select in a vfp cursor returns the correct value but in a MEMO field. I get the same problem if I use the the STR$ function or even a literal. select STR$(num) or select ' ' as field1 both create memo fields instead of a character field with a length of 1.

This is dynamic so I'm using SQLEXEC vs a view.

Any ideas?