>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.
If it's not broken, fix it until it is.
My Blog