January 16th, 2004, 08:10 AM
searching empty coloumns
i have a little problem. How can i search for empty coloums. Say, there is an Coloums "File" and there is nothing saved. (THis coloums is also untouched.) How can i search for Rekords with this coloumn "file" empty.
SELECT * FROM Table WHERE file LIKE '' doesn't work.
SELECT * FROM Table WHERE file LIKE NULL returns a syntax-error. :-(
Please help me, thanks.
January 16th, 2004, 09:04 AM
WHERE Mycolumn IS NULL
Do note, that it "MyColumn" is a character column, '' is not the same as NULL, unlike in Oracle.
Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle