I am using ODBC to connect crystal report to MYSQL database. I am wondering why i cant select a data from a tables where a field in a table is equal to "" (that mean nothing in the field,but not null,just nothing).

I right click on the field at the table..then click select expert
-> click equal to "" , but when run the crystal report,nothing select? how can i fix this problem?

thanks for help.