That's right, Alan.....and I've been bitten by those leading '0's being taken as numbers in octal.
DJ On 05/24/2011 10:48 AM, Alan Altmark wrote: > On Tuesday, 05/24/2011 at 11:30 EDT, Dave Jones <[email protected]> > wrote: >> num1 = right(num1,3,'0') >> num2 = right(num2,3,'0') >> num3 = right(num3,3,'0') >> num4 = right(num4,3,'0') >> padded_IP_addr.i = num1 || '.' || num2 || '.' || num3 || '.' || num4 > > That's ok for an intermediate result for sorting, but dogma requires that > include "i" in there so that you can relate it back to the original list. > A dotted-quad element with leading zeros is traditionally interpreted as > octal. > > Alan Altmark > > z/VM and Linux on System z Consultant > IBM System Lab Services and Training > ibm.com/systems/services/labservices > office: 607.429.3323 > mobile; 607.321.7556 > [email protected] > IBM Endicott > -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
