>Hello all!
>Who know function or metodology in T-SQL like
>AT(cSearchExpression, cExpressionSearched [, nOccurrence]) in VisualFoxPro.
Sergey,
You can use LIKE statement, or CONTAINS function
( Note that CONTAINS is only applicable for full-text indexed columns )
USE Northwind
GO
SELECT * FROM Customers
WHERE CompanyName LIKE '%Rest%'
GO
SELECT * FROM Customers
WHERE CONTAINS(CompanyName, 'Rest')
GO
Cheers,
Zoran