Re: Number formats

From: Dan <gndiving_at_erols.com>
Date: Sat, 13 Feb 1999 23:32:29 -0500
Message-ID: <7a5jlb$ss6$1@winter.news.rcn.net>

how about

lpad(column_name,38,'0')
this will pad the column with leading zeros

Pilsbury wrote in message <01be4e05$426152b0$0159ea9e_at_mothergoose>...
>Hi people,
>
>Can anyone tell me how to pad a field which is declared as an integer (or
>number(38)) with zeros please? The field is always 4 digits but cannot be
>declared as CHAR as the Pro*C code I've got doesn't handle this. Each time
>I input 0005 for example, it is converted to 5 which is no good. Any
>suggestions would be greatly appreciated.
>
>TIA
>
>Pilsbury
Received on Sat Feb 13 1999 - 22:32:29 CST