just starting to play around and test amazon's redshift. One thing I need to do that i can easily do in sql is change userip to integer. This is done in mssql with a scalar function that uses parsename to break up the ip numbres and multiple by them by constants.just starting to play around and test amazon's