>>Hi All -
>>
>>I have this query defined.
>>

select * from TIP_Ledger where FundType='RTA' and isnull(checknumber,'')=''

>>
>>Interestingly, it produces the records specified and also those where checknumber is blank but not null. This is good but a surprise to me. I was wondering if it can be relied upon or is it just a quirk.
>>
>>Thanks for your shared knowledge.
>
>Of course you will get blank checknumbers too.
>The whole point if ISNULL() function is to convert NULLs to something that isn't null.
>if you want to get ONLY NULLs:
>

>select * from TIP_Ledger where FundType='RTA' and checknumber IS NULL
>

Thanks Borislav, I just wanted to make sure.