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: