[dba-SQLServer] comma delimited list

Wow.  Cool.  I have never come across that before.  I can't wait to try
it.  I have always resorted to comma delimited lists.  Thx.  D



Message: 8
Date: Tue, 15 May 2007 19:44:14 -0700
From: "kens.programming" <kens.programming at verizon.net>
Subject: Re: [dba-SQLServer] IN() or NOT IN()
To: <dba-sqlserver at databaseadvisors.com>
Message-ID: <001401c79764$1ec020a0$6b01a8c0 at Stoker.com>
Content-Type: text/plain; charset=windows-1250

You shouldn't have to use a comma limited list, just square brackets to
designate your sets.

IN ([4-9], [A-M])
IN ([^1-3], [^N-T])
NOT IN ([1-3], [N-T])
NOT IN ([^4-9], [^A-M])

Ken