I'm looking to have a user defined function or a function i can include in a new field in the table itself based on the existing field named: code
i have a table with a field with the following data:
code = "AB, BC, CD"
this field has variable length. so there could be x number of codes.
i would like to convert the field to: <a href='mypage.asp?code=' & code1 & "'>" & code1 & "</a>"
and then loop thru all codes.
thank you all.