Posted by David Portas on 11/29/05 17:49

cyber0ne wrote:
> My use of wildcards thus far has been limited to matching a given
> string anywhere in a column as follows:
>
> SELECT * FROM Table WHERE Column LIKE '%string%'
>
> However, I'm wondering if there's a way to do this in reverse. That
> is, is there a way to match the column anywhere in the string?
> Pseudo-coding it as:
>
> SELECT * FROM Table WHERE 'string' LIKE %Column%
>
> What I'm trying to match is network addresses. Most of the stored
> addresses in this table are exact (i.e. ip-1-2-3-4.location.isp.com)
> but sometimes they encompass an entire group (i.e. location.isp.com).
> When an exact address is given in the code I'm writing, it needs to
> match any rows that contain its exact self or contain a shortened
> version of which it is part.
>
> Any ideas?
>
>
> -cyber0ne
> http://www.cyber0ne.com


SELECT *
FROM Table
WHERE 'string' LIKE '%'+Column+'%' ;

--
David Portas
SQL Server MVP
--

[Back to original message]