Re: SQL string matching

abracad wrote:

>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?
>

You could try this:

SELECT desc
FROM Table1
WHERE ' '||desc||' ' LIKE '% tin %';

regards,
Lauri Pietarinen Received on Sun Mar 09 2003 - 01:02:34 CST