Which T-SQL predicate allows you to search columns containing character-based data types for precise or fuzzy (less precise) matches to single words and phrases?

Place the mouse cursor HERE for the answer

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

1. Ensure that the table has a unique, not null column (e.g. primary key)
2. Create a full text catalog in which to store full text indexes for a given table
3. Create a full text index on the text column of interest

4. SELECT * FROM TableName WHERE CONTAINS(ColumnName,'bank')

---

Secolul XXI ori va fi religios ori nu va fi deloc

The answer is: Use the CONTAINS predicate.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro