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.