[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-%'
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