Re: part removal
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/23/04
- Next message: MA: "CHECK DOUBLE RECORD"
- Previous message: GW: "Data Synchronization"
- In reply to: GW: "part removal"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 20:54:04 -0500
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.
- Next message: MA: "CHECK DOUBLE RECORD"
- Previous message: GW: "Data Synchronization"
- In reply to: GW: "part removal"
- Messages sorted by: [ date ] [ thread ]
