Hi,
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)
SQL specifications.
Empty string and NULL are two different thinks.
Regards Gaetano Mendola
---------------------------(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
