Simple SQL ASP Question

Well it should be simple for most folks...but i'm having a problem. I have a simple query that selects all records that mach a full text search string. My query is:

mySQL = "SELECT * FROM current where match (articlebody,title) against ('pro-active') order by " & sort

(articlebody,title) is my index and sort is a variable that allows the user to select the column heading on a table and have it sort by that item.

This works very well. However, i'd like to substitue the AGAINST ('search string') for a variable. I have tried several combinations of things i think would work...but i get errors every time.

Can someone recommend a way i can put a variable in the AGAINST argument?

Thank you,

Sean

Try

Perfect...thank you!