We've used this exact technique in a table called "ANY_DATE_FORMAT" since
1997... admittedly in Oracle, but the principle still applies.

It's great for coalescing the number of states necessary to implement
parsers. :)

--andy


On 8/18/07, Rod Dav4is <[EMAIL PROTECTED]> wrote:
>
> Conventional usage is as follows:
>
>     ... WHERE column-name LIKE "string"
>
> Which, of course, selects rows where the values in the named column
> match the string, which can, and usually does, have wildcards.
>
> I have been using an inverted arrangement:
>
>     ... WHERE "string" LIKE column-name
>
> This allows the wildcards to be in the named column of the database.
> What possible use could this be? It's hard to even get your head around
> it.
>

Reply via email to