Posted by Erland Sommarskog on 03/19/06 13:06

(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'



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Query Problem
• Prev in forum: Re: SQL query - duplicate records - different dates - how to get only latest information?
• Thread view: Re: SQL query - duplicate records - different dates - how to get only latest information?

[Reply to this message]