SQL string matching

I am trying to create a SQL query that will search a text field for a particular word, say 'tin'. I want to ensure it finds only the word
'tin', and not the characters 'tin' as part of another word, eg
'postings'.

I can create a query such as:
SELECT desc
FROM Table1
WHERE desc LIKE '% tin %' OR desc LIKE 'tin %' OR desc LIKE '% tin' OR desc='tin'

But is there a shorter or more efficient way of accomplishing the same objective?

Thanks in advance Received on Sat Mar 08 2003 - 18:03:41 CST