update masteraccounts set maexpiredate='4/1/98' where maexpiredate =
'4/15/98'
Put this in ISQL/W under the Emerald database.
Enjoy!
-Joe Marcelletti
At 02:18 PM 3/3/1999 -0800, you wrote:
> We need to change our billed through and paid through customer
> dates from
>the 15th to the 1st. I was wondering if there is some sql statement I could
>run that could replace the 15th on these two fields the the 1st. Ex.
>everyone with 5/15/99 or 4/15/98 etc changed to 5/1/99 and 4/1/98. Is this
>possible.
>
>Thanks for the help.
>
>Jason Powell
>
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
Tellurian Networks (Formerly Garden Networks)
Quality Nationwide Internet Access since 1995
Access, Co-location, Development & Consulting
http://www.tellurian.net (973)300-9211 Ext.106
Finger joem@tellurian.net for PGP public key
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html