Problem is, when you do NOT demand the correct datatype, the database will choose, ie, an IMPLICT conversion will occur - you have a string column a nd a numeric between, SO the Oracle db can choose convert the column to number (and the logic will work), OR it can choose convert the number between to string, thus bringing back the problem. The answer is ONE, do EXPLICITALY what you want.

Regards,

Chiappa