part removal

From: GW (anonymous_at_discussions.microsoft.com)
Date: 09/23/04


Date: Wed, 22 Sep 2004 18:23:19 -0700

Hi,

I've a problem to remove certain character from one
column/field eg. 500000000000ABC. How to remove ABC ?

Thanks in advance.