Auto Hyperlink Words in Content that Exist in DB

[gwrman]

in say, a dictionary of terms with definitions, (in a database) how can i hyperlink (automatically) words within the definition text for which a definition also exists.

url structure is like this

http://www.site.com/glossary?word=someword

Then - in the definition of "someword" there is a word that also has a definition in the database. I'd like to auto hyperlink it to that definition.

any ideas?

also, since the data is all coming from a database, what if one of the words to be replaced has not yet come up in the loop? (...or would it be okay since EVERYTHING should be in the recordset?

Also - in each block of definition text, there could potentially be multiple words for which definitions exist. - would this work here too?

Thanks again!