I&#039;m working on a search query and I&#039;m trying to figure out how to use a condition in my where clause so a user could select all columns or use a keyword filter. I normally do something like this:<BR><BR>Select * From tblFoo<BR>Where ((@UserInput = &#039;All&#039;) or (col1 = @UserInput))<BR><BR>But I&#039;m trying to use the FreeText Function like this<BR><BR>Select * From tblFoo<BR>Where ((@UserInput = &#039;All&#039;) or (FreeText(col1, @UserInput)))<BR><BR>and my idea doesn&#039;t work in this situation(I&#039;m guessing it&#039;s because it never uses the switch, it just looks for &#039;all&#039; in the column). I was wondering if anyone has any ideas on how to accomplish this without having to exec the whole query as a string. If there is a better way to implement this logic, your comments are welcome.<BR><BR>Thanks<BR>