General information
Forum:
Microsoft SQL Server
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only