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