Did you try a BIT type?
>There was a display problem with my previous msg.
>So here it is again.
>
>Hello,
>
>I get a cursor from a MySQL table with a SQLEXEC().
>I need to retrieve a value from a boolean field (.T. or .F.).
>But I can't find a field datatype in MySQL wich correspond to a boolean.
>I absolutely need to get .T. or .F. from this field because I'm not only connecting to MySQL but also other backends.
>Is there an issue ?
>
>Thanks for your help.
>Regards,
>Steph
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.