chester c young wrote:
I'm trying to use substr() and position() functions to extract the full host name (and later a domain) from a column that holds URLs.substring( href from '.*://\([^/]*)' );
Ok, your solution looks better than mine... but I have no idea how to interpret that, time to consult some manuals.
-- Paul Lambert Database Administrator AutoLedgers ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend