Re: [Emerald] SQL Command

PowerNet ( (no email) )
Mon, 14 Feb 2000 11:11:26 -0500

Josh,

I have an off the list question for you if you don't mind, but I don't=
recall your private email.

Thanks,
John
psc5@powersupply.net

*********** REPLY SEPARATOR ***********

On 2/14/00, at 11:07 AM, Josh Hillman wrote:

>From: Howard A. Brooks <admin@iamnow.net>
>>Could someone please give me the SQL command to change all the Paid Thru
>and Bill Thru dates to 01/31/2000, please?
>
>update masteraccounts
>set paidthru=3D'1/31/2000', billedthru=3D'1/31/2000'
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart