I've been asked to extract product related data from the database and include the full URL.

I've been looking over the functions but I can't seem to find a function or stored proc that will...