Re: numbers in varchar2 field

From: Michael O'Shea <michael.oshea_at_tessella.com>
Date: 9 Jun 2006 01:36:01 -0700
Message-ID: <1149842161.621858.79670@c74g2000cwc.googlegroups.com>

> Sybrand Bakker wrote:
>
> You are ending up in a mess, and should convert the column to a
> number(n) asap. Leading zeroes is a *display* issue.
>

Hi Sybrand, just a comment on your helpful post.

The OP might have a 4 digit *varchar2* of 4231 and a 9 digit *varchar2* of 000004231. Further he raises the issue of leading zeroes but does not elaborate on their significance. According to your suggestion they would both be converted to *number* of 4231. I don't know his data - these leading zeroes may be significant.

Regards
Mike

TESSELLA Michael.OShea_at_tessella.com

__/__/__/  Tessella Support Services plc
__/__/__/  3 Vineyard Chambers, ABINGDON, OX14 3PX, England
__/__/__/  Tel: (44)(0)1235-555511  Fax: (44)(0)1235-553301

www.tessella.com Registered in England No. 1466429 Received on Fri Jun 09 2006 - 03:36:01 CDT