I have a page that displays text from a nvarchar (8000) field in my database as: <%=(report_results.Fields.Item("comments").Value)%>
I am also passing a 'keyword' from the previous page and I retrieve it with: request.form("keyword")
I want to highlight the value I pass as keyword in the text that is displayed on the page. Example:
I my keyword is "second"
I want the text to display as "This is the second time I try this" or something of that nature. How can I do this ?
I am using SQL 2008 and ASP Classic