Posted by clare at snyder.on.ca on 03/19/06 20:17

On Sun, 19 Mar 2006 11:06:27 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> wrote:

> (clare at snyder.on.ca) writes:
>> There is ONE condition that I forgot to mention in the polno field.
>> Not only do they add a different suffix for every year's renewal(which
>> now appears to be a non-issue) but if a policy is cancelled, it can
>> have CANC at the end, or NOTRENEWED.
>
>AND polno NOT LIKE '%CANC'
>AND polno NOT LIKE '%NOTRENEWED'


In my last post I said:
I have tried putting "and polno not like '1932700%CANC'" in the line
before "AND c.email IS NOT NULL"and I still get the cancelled policy,
but only once - without the CANC on the polno.
The cancelled policy still shows up, butas due for renewal, and not
cancelled.

Also said "Putting the line in after the "Where polno like" line has
no effect.", in other words, putting it there does not remove either
the duplicate OR both incidents of the record.



I think I need to somehow do a second query on all cancelled policies
(polno like '%canc") and somehow tell the query to NOT select the
lastname and email addresses for anyone on THAT list. Some sort of an
EXCLUDE function - which I don't understand.

*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***

[Back to original message]