Convert DB text to links

Hi,
 
I need code to convert text from an ms access db into keyword links in asp/html.
 
In ms access there is a table that contains keywords separated by commas (live bands, musicians, performers, etc) where each phrase is to be converted into a separate html text link.
 
Possible? Or not???
 
Thanks in advance.

myArr = split( [your_phrase_list_here],",")

for i= 0 to ubound(myArr)
    '''build link here - somethig like:
    '''-----------------------------------------
    response.write( "http://" & myArr(i) )
next

Hi webber123456,
 
Thanks for your quick reply and nifty code.
 
I'm almost there, just having a little trouble displaying the keywords as actual text links. What I'm getting with this line:
 
response.write( "http://" & myArr(i) )
 
is: http:// live bands, http:// musicians, http:// performers, etc...
 
What I'd like is for each key phrase to become an active text link that can in turn be used as a keyword/keyphrase search in the database.
 
The actual script I'm using is this:
 
Dim MyStr, MyArr
MyStr = "<%=oRS("keywords")%>"
MyArr = Split(MyStr, ",")
for i= 0 to ubound(myArr)
   document.write("http://" & myArr(i) & " ")
Next
 
("response.write" didn't work for me, but "document.write" did. Must be something to do with me being a bit of a newbie!)
 
Cheers

You will need to add a line break for the individual links.  Since it outputs to a browser the line break will be in html format

response.write( "http://" & myArr(i)  & "<br>" )

Thanks webber123456, but the keywords have been successfully split by using "& " ".
 
Using the current code will produce a http:// tag in front of the keyword, so you get for example: http://musicians. And this won't link to anything of consequence.
 
What I'd like to know is how to use the split text phrases to get a *reference* to a http link. Eg: <a href="http://www.awebsite.com/urlreference1.asp>musicians</a>, <a href="http://www.awebsite.com/urlreference2.asp>performers</a>, <a href="http://www.awebsite.com/urlreference3.asp>live bands</a>
 
Any ideas?
 
Cheers