Hi, I'm trying to do a simple query in a HSQL database where I'm looking to filter a text value. I'd like something simple like:
SELECT * FROM "quInventoryMixed" WHERE "PartType" <> 'Toolbox' but when I run the query it not only filters out all the records with the PartType field that is "Toolbox" but also all that null or empty. I tried to be clever with the ifnull function but get nowhere. Any suggestions? thanks, -- ===================================== Sepehr (Sep) Kiani, Ph.D. Email: [EMAIL PROTECTED] http://pergatory.mit.edu/skiani =====================================
