Re: [Emerald] Script to change BilledThru?

Dale E. Reed Jr. ( (no email) )
Thu, 29 Jul 1999 09:30:25 -0700

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

Eric wrote:
>
> 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.

Try this:

UPDATE MasterAccounts
SET BilledThru = '2/1/99'
WHERE BilledThru Between '2/1/99' and '3/1/99'

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

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