>Hi, all...
>
>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?
>
>Thanks,

Kevin,
Tyr the LIKE operator. Ex. performed on pubs database in SQL Server

select title from titles where upper(title) like '%'+'THE'+'%'

HTH.

Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao