Question of the Day

Re: QOD 70-442 2006-09-16

xmldeveloper — Sun, 05 Nov 2006 13:44:32 GMT

The answer is: Use the CONTAINS predicate.

Re: QOD 70-442 2006-09-16

crestinul — Sat, 04 Nov 2006 19:56:45 GMT

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

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

```
 
```

QOD 70-442 2006-09-16

xmldeveloper — Sat, 16 Sep 2006 08:19:54 GMT

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