I have question:
why such condition: foofield not like '%bar%'
where foofield is varchar
returns false (or rather even ignore row) on record where foofield is null but returns true on records where foofield is '' (empty string)
regards Robert
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
