How do you change the datatype to a hyperlink?

I’m trying to write a script that formats a word, captured from 1 database, reformat it as a hyperlink, write it to a different database.