Re: Removing Leading Zeros Using SQL
From: Ken Denny <ken_at_kendenny.com>
Date: Fri, 31 Oct 2003 17:17:17 GMT
Message-ID: <Xns94257CB574CA7kendenny_at_216.77.188.16>
Date: Fri, 31 Oct 2003 17:17:17 GMT
Message-ID: <Xns94257CB574CA7kendenny_at_216.77.188.16>
forlist2001_at_yahoo.com (kumu) wrote in news:a44abd39.0310310826.2a8a73a5 _at_posting.google.com:
> Hi, Is there a way to write an update statement to remove leading
> zeros from a column? The column is a varchar field and the number of
> zeros vary.
> Thanks in Advance
UPDATE table
SET column=LTRIM(column,'0');
-- Ken Denny http://www.kendenny.com/Received on Fri Oct 31 2003 - 18:17:17 CET