>>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 don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place