Zoran.
Thank you for your answer.
But charindex() function solve my problem.



>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

---- OR ----

SELECT * FROM Customers
WHERE CONTAINS(CompanyName, 'Rest')
GO