Removing Leading Zeros Using SQL

From: kumu <forlist2001_at_yahoo.com>
Date: 31 Oct 2003 08:26:01 -0800
Message-ID: <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 Received on Fri Oct 31 2003 - 17:26:01 CET

This message: [ Message body ]
Next message: Frank: "Re: count (1) and count (*)"
Previous message: jdestreel: "Enterprise Manager 2.2 on NT4 gathering from HP/UX11 and 8.1.7.4"
Next in thread: Ken Denny: "Re: Removing Leading Zeros Using SQL"
Reply: Ken Denny: "Re: Removing Leading Zeros Using SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message