Hi Sepehr,
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.
(Usually, an explanation where "nowhere" is located and how it looks
like helps others helping you :)
> Any suggestions?
AND "PartType" NOT NULL
?
Ciao
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
