Hi Jaimie,

If " |44|-2" is constant string, then u could use "Replace" command with
replace string as ''.

Try this.......

Kannan M

----- Original Message -----
From: "Jaimie Freitas" <jaimie.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, April 23, 2003 1:01 PM
Subject: Beginner Question


> Hi All
>
> I need to remove all the |44|-2 from the end of all the phone numbers in
my
> database. Any idea how I can do this?
> 02077940500 |44|-2
>
> Thanks for any help in advance
>
> warmest regards
>
>
> Jaimie Freitas
> The contents of this e-mail are strictly confidential and are intended
only
> for the addressee named above. This e-mail may contain confidential or
> privileged information. If you are not the intended recipient of this
> message please notify the sender immediately. The contents of this e-mail
> must not be disclosed to any other person or copies taken. Please note
that
> any views expressed in this e-mail may be those of the originator and do
not
> necessarily reflect those of this organisation. Internet e-mail is not a
> secure communications medium. Please note this lack of security when
> responding by e-mail. Accordingly we give no warranties or assurances
about
> the security and content of this e-mail and its attachments. Neither
Thermo
> Electron Corporation nor the sender accepts any responsibility or
liability
> for viruses and it is your responsibility to scan the e-mail and
> attachments. Any liability arising from any third party acting on any
> information contained in this e-mail is hereby excluded. (c)
Thermo
> Electron Corporation www.thermo.com
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page