""A_Michigan_User"" <Michigan_RE_M0VE@ameritech.net> wrote in message
news:eI6tz4GfGHA.3488@TK2MSFTNGP02.phx.gbl...
>
> How in the world would you do this?
>
> The user enters a word like: "BROWN".
>
> The database contains a VarChar() field like: "RED,GREE*,BR*N,BLU*"
>
> A match is found because the 3rd word "BR*N" matches "BROWN".
>
> I guess I would have to use some combination of:
> LIKE (for the wildcards)....
> REPLACE (to replace the user-friendly *, with the T-SQL %
> character)....
> IN (to match a list of values like RED,GREEN,BROWN,BLUE, etc)
> Also... the wildcard characters are in the database... NOT passed from
> the user.
>
> But I can't seem to get them all working at the same time.
>
> Help!
>
> (I'm working with MS SQL 2000, asp.net, vb.net... and wanted to use a
> parameterized query.)
>
>
>

On Sat, 20 May 2006 20:33:33 -0400, "A_Michigan_User" wrote:

>
>How in the world would you do this?
>
>The user enters a word like: "BROWN".
>
>The database contains a VarChar() field like: "RED,GREE*,BR*N,BLU*"
>
>A match is found because the 3rd word "BR*N" matches "BROWN".
>
>I guess I would have to use some combination of:
> LIKE (for the wildcards)....
> REPLACE (to replace the user-friendly *, with the T-SQL % character)....
> IN (to match a list of values like RED,GREEN,BROWN,BLUE, etc)
> Also... the wildcard characters are in the database... NOT passed from
>the user.
>
>But I can't seem to get them all working at the same time.
>
>Help!
>
>(I'm working with MS SQL 2000, asp.net, vb.net... and wanted to use a
>parameterized query.)
>
>