Very Computer

how find a word in a string???
Indeed for example, if i want find "TS" word, my SQL query is:

select * from table where field LIKE '%TS%';

However with this query, MySQL return fields which contains 'circuiTS'
too.I want find only the 'TS' word. I've try with a scpace caracter
before and afer 'TS', but if this word is at begining or at the end of
the field, nothing is returned...
do there be a special caracter in SQL to mean a limit word like perl or
php (\b)???

Thanks you very much

Check out the full text indexing abilities supported by SQL Server 7.0 /
2000.
You should also find that performance improves by using full text indexes.

Documentation on full text indexes can be found in the SQL Server Books
Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.