Is there a built-in SQL function that sorts by relevance?
I've been trying to do this using my query and I'm getting an error stating that:
Microsoft OLE DB Provider for SQL Server error '80040e14'
'RELEVANCE' is not a recognized function name.
This is my query:
SELECT Article_Date, Headline, Headline, teaser, id, Rank, Headline_Photo, Headline_Photo_Alt, Video, Audio, Multimedia FROM Articles_e WHERE Visible = 1 AND '11/30/04' >= Publish_Date ORDER BY RELEVANCE();