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 create the full URL for me.
Has anyone had a similar need? How did you accomplish it?