>>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