On Tue, Dec 05, 2006 at 09:58:02AM -0700, Dennis Cote wrote: > select > case > when substr(ip, 2, 1) = '.' then -- one digit first quad > case > when substr(ip, 4, 1) = '.' then -- 1 digit second quad > case > when substr(ip, 6, 1) = '.' then -- 1 digit third quad
I've been wanting glob/regexp substrs, split... Nico -- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
