help needed

------=_NextPart_000_000B_01C6D66D.F86DE9D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi, I are working with visualfox 6.0 and mysql server 4.1 and odbc =
driver 3.51.11.00 11 feb 2005

I have a table with a colum with an "F" or an "f"

this does not work, because ignore the where and bring to me all the =
records

SELECT status, no_documen FROM FACTHEAD where status=3D"f"

I also try this and works fine in the mysql query browser but in fox =
bring to me again all the records ignoring the lowercase

SELECT status, no_documen FROM FACTHEAD where hex(status)=3Dhex("f")


what can I do?

Saludos
=20
=20
=20
Daniel Hernandez Finamore
Director Ejecutivo
ISP, S.A. de C.V.
Telefono Conmutador 0155-5243-5222
http://www.bestcommerce.com.mx
=20
Este mensaje y cualquier documento que se adjunte, son para el uso =
exclusivo de la persona o entidad a la cual se encuentra dirigido y =
podr=EDa contener informaci=F3n legalmente considerada como confidencial =
y privilegiada, exenta de ser revelada a terceros. Si usted no es el =
leg=EDtimo destinatario de esta comunicaci=F3n, consid=E9rese notificado =
que est=E1 estrictamente prohibido cualquier tipo de reproducci=F3n y =
distribuci=F3n de este mensaje y cualquier documento adjunto. Si usted =
ha recibido este mensaje por error, por favor notifique inmediatamente =
esta situaci=F3n por correo electr=F3nico al remitente original y borre =
completamente de su computadora el mensaje y cualquier documento =
adjunto. Para establecer o formalizar alg=FAn tipo de acuerdo entre ISP, =
S.A. de C.V. y su compañía, es necesario que se firme por los =
representantes legales de ambas compañías un acuerdo por escrito que =
incluya todos los t=E9rminos y condiciones de la transacci=F3n =
respectiva.

This message, together with any attachments, is intended only for the =
use of the individual or entity to which it is addressed and may contain =
information that is legally privileged, confidential and exempt from =
disclosure. If you are not the intended recipient, you are hereby =
notified that any dissemination, distribution, or copying of this =
message, or any attachment, is strictly prohibited. If you have received =
this message in error, please notify the original sender immediately by =
return E-mail and delete the message, along with any attachments, from =
your computer. In order to establish a formal agreement between ISP, =
S.A. de C.V. and your company, it is necessary to execute a written =
document signed by the proper representatives of each company, including =
all the terms and conditions of the relevant transaction.



------=_NextPart_000_000B_01C6D66D.F86DE9D0--