[Emerald] Script to change BilledThru?

Eric ( ejensen@accnorwalk.com )
Thu, 29 Jul 1999 09:50:36 -0400

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: PowerNet: "[Emerald] SCRIPT"
Next message: Eric: "[Emerald] RadiusNT not trimming email anymore?"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] Script to change BilledThru?"

Could someone help me write a script to change the "BilledThru" in
"MasterAccounts" to the date specified in "PaidThru"? Or, if there is a way
to use wildcards when updating a record to search out a range of dates like
'1999-02-** 00:00:00'?
I tried this...
----------------
UPDATE MasterAccounts
SET BilledThru = '1999-02-01 00:00:00'
WHERE BilledThru LIKE '1999-02-%'
GO
-------------
There were no syntax errors messages, but it says that 0 rows where effected.
Thanks,
Eric Jensen

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

Previous message: PowerNet: "[Emerald] SCRIPT"
Next message: Eric: "[Emerald] RadiusNT not trimming email anymore?"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] Script to change BilledThru?"