Re: 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

It dont qualify as shorter or more efficient, but it is a different
approach: