Cant select the data from database where field = ""

[OrangKampung]

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.

[sotoasty]

not really the conventional method but you could try something like.

SELECT * FROM A WHERE Ts < char(0);

Or in the select records expert use

"is"
"less than"
and
"char(0)"

Works on my MySQL and CR (Original CR with VS 6.0)

Hope this helps.

[Thread1]

..Or trim the field

SELECT * FROM Table1 WHERE TRIM(Field1) = '';