>>>Hi All
>>>
>>>I'm looking for a T-SQL replacement for the VFP AT() function.
>>>
>>>I'm passing the where clause to a stored procedure and need the equivalent of
>>>
>>>
>>>** SrchWord is entered by user
>>>** Script is a field within the table
>>>WhrClause = "AT(Lower(SrchWord), Script) > 0"
>>>
>>>
>>>thanks
>>
>>Take a look at CHARINDEX and PATINDEX functions in BOL.
>
>CharIndex was what I was looking for, thanks
You might also take a look at "LIKE" in TSQL
http://bytes.com/topic/sql-server/answers/81467-using-charindex-vs-like-where