seems like gotcha :)) use: SELECT * FROM testdb WHERE col1 LIKE '%' OR col1 IS NULL;
On Wednesday 03 of March 2004 16:41, Jonas Lindén wrote: > Hello list > > SELECT * FROM testdb WHERE col1 LIKE '%' > > The above SELECT statement doesnt return columns with NULL values. Should > it? ;). Should I approce the problem in another direction? > > Regards > /Jonas -- Z lepimi pozdravi, Bostjan Skufca sistemski administrator Domenca d.o.o. Tel: +386 4 5835444 Fax: +386 4 5831999 http://www.domenca.si -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]