Re: where clause on null string

From: Zorglub <no_at_mail>
Date: 14 Nov 2001 17:42:10 GMT
Message-ID: <Xns9159BE68A3FFFzorglubID1923@213.228.0.136>

Yes, the right syntax was IS NULL and I didn't known about it..

Thanks !!

davide_at_yahoo.com wrote in news:9sr4l6$14pu82$2_at_ID-18487.news.dfncis.de:

> Zorglub <no_at_mail> wrote:

>> why a WHERE myVarCharCol='data' OR myVarCharCol=''

>
> If the contents of the field is NULL, you should check for 'is null',
> not an empty string. And are you sure that the field is not padded with
> spaces ?
>
> What happen if you ask
>
> where myVarCharCol like 'data%' ?
>
> Davide
>
Received on Wed Nov 14 2001 - 11:42:10 CST