Re: [Emerald] QUERY HELP!

Dale E. Reed Jr. ( (no email) )
Sat, 26 Feb 2000 10:51:39 -0800

PowerNet wrote:
>
> What Query would I use to find all inactive accounts?

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