Select CustomerID From MasterAccounts Where maActive = 0
> What Query would I use for all expired accounts?
Select CustomerID From MasterAccounts Where maExpireDate < GetDate()
The later doesn't take into consideration extensions/limits, though.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart