Re: part removal

From: Paul Nielsen (pnielsen_at_us.ci.org)
Date: 10/12/04 

Date: Tue, 12 Oct 2004 01:48:12 -0600

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...
>> Hi,
>>
>> I've a problem to remove certain character from one
>> column/field eg. 500000000000ABC. How to remove ABC ?
>>
>> Thanks in advance.
>
>

Relevant Pages