Hi,

You can use "replace" function to solve your problem.

Example:

SELECT REPLACE('abcdefghicde','cde','xxx')

here, all occurance of 'cde' will be replced by 'xxx'

hope this will help you.

Regards,
Bajal

--- Melissa Faga <[Email Address Removed] wrote:
> 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]
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


=====
With warm wishes,
S.Bajal Mohamed
Tek-Modular Sdn Bhd
lot 4858, Jln Panglima
KB KA 3131
Brunei Darussalam.
Tel : 673 + 3 + 331415 (off)/ 332785 (Res).

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
MS Sql Server LazyDBA home page