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