I pass it some data for the criteria, and it returns rows. There are brackets because there are 2 other tables LEFT joined in. Anyway.. Now what I want is this: WHERE (@term LIKE @criteria) That way.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results