>update masteraccounts
>set overdue=[new value]
>where overdue=[old value]
>
update masteraccounts
set paidthru=9/30/1999
where paidthru=10/1/1999
Would this set all the MBR's that have a Paid Thru of 10/1/99 to 9/30/99?
What happened is when we started inputting customers into Emerald we set
the Paid Thru and Expire and Billed Thru dates as 10/1/1999 where we should
have put them to 9/30/1999 which is what they are actually paid thru...
Basically, I'd like to change all the Paid Thru, Expire and Billed Thru
that are 10/1/1999
Thanks, still learning...
David
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart