Query with hexadecimal characters

Hello!
I am having a problem doing a query with hexadecimal
characters through ODBC. The hexadecimal characters
are inside a character filed. It would be something
like:

SELECT * FROM MYTABLE WHERE COLUMN1 < 'XXXXXX'

but instead of the X's there are x'FF' characters...
The query is accepted, but the result is not
consistent... it returns an empty result set. Does
anyone know if I'm missing something?

Thanks in advance!
Luciano

__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail