[Emerald] Script to change BilledThru?

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

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-%'
There were no syntax errors messages, but it says that 0 rows where effected.
Eric Jensen

For more information about this list (including removal) go to: