Re: sql script which doesn't find everything
From: Simon Hedges <shedges_at_hhhh.freeserve.co.uk>
Date: Sat, 10 Apr 1999 13:40:11 +0100
Message-ID: <7engme$r86$1_at_news5.svr.pol.co.uk>
Date: Sat, 10 Apr 1999 13:40:11 +0100
Message-ID: <7engme$r86$1_at_news5.svr.pol.co.uk>
Are any of your subscription durations null?
If so, try 'where (subscription_duration not like 'F' or subscription_duration is null)'.
The reason for this is that 'null' is neither like F or unlike F - it's an
unknown.
If the column containst no nulls, then I'm stumped!
Simon Hedges
Gloucester
UK
Received on Sat Apr 10 1999 - 14:40:11 CEST