Robert Partyka wrote:
> 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