[Mailman]

Hi all, I'm trying to get a result from a simple query. Unfortunatly the result did not come.

Here is the problem:

Say I have a table with 20 records, each of those 4 queries should return 5 records, but only 1 did. 5 records had no value for field1, 5 records had no value for field2, 5 records had no value for field1 and field2 and finally 5 records had value in field2.

select * from table where field1 = ''
select * from table where field2 = ''
select * from table where field1 = '' and field2 = ''
select * from table where field2 <> ''

The last query return me 5 records. All other queries return 0 row no error ???

Note:field1 and field2 are of type varchar

What did I miss I'm clue less

Thanks to anyone that can help!

[ArksI]

what about the LIKE comparison of varchar-s?

[Mailman]

thanks i'll give it a try

[Mailman]

I got it working

select * from table where (field1 is null or field1 = '') and (field2 is null or field2 = '')

make the trick, thanks...