We have a search/filter capability in our product, where someone can type a partial text string into a variable called cMySearch, and then we do a
SELECT * FROM WHERE AT(cMySearch,Field1) > 0 OR AT(cMySearch,cField2) > 0 OR... [you get the idea]
We're moving this functionality into SQL Server, and I came across the CONTAINS function that you can use in a SQL statement...except that you need to have full-text indexing on. This sounds like it might be a bit of a maintenance issue.
Bottom line is...is there a native function in T-SQL [using SQL Server 2000] that allows me to do the equivalent of an AT() in a SQL WHERE clause, without having to install full text indexing or other features?
