There is a reason why KiX pads out the IP. It is so that string compares would work. By stripping out the spaces, you defeat string compares.
That said, string compares are a lousy way to go. Either use one of the many UDFs out there or else simply break up the IP into octets and convert then to numeric with Val() so that proper compares can be performed.
_________________________
Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.
