Re: Extending expire dates

Dale E. Reed Jr. ( (no email) )
Wed, 02 Apr 1997 02:00:47 -0800

Jeremy Domingue wrote:
>
> If we wanted to extend the expire dates of everyone EXCEPT people that are in our (newly created) semi-annual billing group, what we be the SQL statement that we would use in ISQL?

First do a:

Select * From Groups

And find the GroupID. Then Change the # below to that GroupID and run
the
following query:

Update MasterAccounts Set maExpireDate = '4/20/97'
Where GroupID <> #

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com