I need help with a SQL statement to update a number of records. I have a
table called orders with a field called ordernum. There are a number of
records that have the following structure to them -00004, -00005, -00006,
etc.. I need to go in and replace the - with a zero. Does anyone know the
SQL statement I would need to use.

Thanks,

Melissa


Melissa A. Faga
GIS/DB Manager

City of Redmond
P.O. Box 97010
MS# TCFIS
Redmond, WA 98073

Phone: 425-556-2134
Email: [Email Address Removed]MS Sql Server LazyDBA home page