I have a below query that work fine but I just want to replace "ra*" with a variable. How can I do this?
Code:
SELECT DISTINCT a.[rank], b.Description
FROM CONTAINSTABLE(myTable, *, '"ra*'") AS a
INNER JOIN myTable AS b ON a[key] = b.ID
ORDER BY a.rank desc;
Leave a comment: