call Function in SQL Statement
I'm searching a blog post database field with embedded HTML and highlighting the found strings but it's selecting and highlighting HTML tags breaking the HTML.
I have a regular expression function RemoveHTMLI use to display excerpts without the HTML that I am trying to call from my SQL to prevent tag matches but it does nothing.
Here's the SQL: "SELECT Content_ID, Content_Title, Content_Body, Content_FeaturedImage FROM Content WHERE ((Content_Title) Like ?) OR (" & RemoveHTML("Content_Body") & " Like ?) And Content_Active = 'Y' ORDER BY Content_Title ASC;"
The query runs but it returns HTML. Any ideas?