part removal

Hi,
I've a problem to remove certain character from one
column/field eg. 500000000000ABC. How to remove ABC ?
Thanks in advance.
Hi,
Look into function LEFT or Substring in Books online.
Thanks
Hari
MCDBA
"GW" <anonymous@.discussions.microsoft.com> wrote in message
news:427101c4a10b$e8b2a330$a501280a@.phx.gbl...
> Hi,
> I've a problem to remove certain character from one
> column/field eg. 500000000000ABC. How to remove ABC ?
> Thanks in advance.
|||Use the Replace function
-Paul Nielsen, SQL Server MVP
SQL Server 2000 Bible, Wiley Press
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uZ8KYARoEHA.3252@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Look into function LEFT or Substring in Books online.
> Thanks
> Hari
> MCDBA
> "GW" <anonymous@.discussions.microsoft.com> wrote in message
> news:427101c4a10b$e8b2a330$a501280a@.phx.gbl...
>