All,
ARS 7.01 p4 Oracle 10g Solaris 9 We have a request to format data that is stored in a character field. The data is standard IP addresses: xx.x.xx.xxx The idea is to make each octet three characters by padding zeros. So the previous example would look like: 0xx.00x.0xx.xxx. We are wondering if anyone has any suggestions for doing this when the data is stored in one field. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

