MSSQL LIKE and IN statements in ADO problem

[gregarican]

Raja Raman wrote:

> Hi Gregarican,
>     Thanks for sharing your code. One needs to add the % signs if one
> wants to do wildcard searches using LIKE in the SQL server.
> Do as Roger and Steve suggested '%raj%', now you can find the names
> containing the word raj anywhere in the column.
> just value = 'raj' is only going to fetch you fnames that == 'raj'
> Originally my problem was using the LIKE statement itself. But I guess
> you already know.




Duhhh on my part. A little behind the curve as I'm recouping from adult
chicken pox. Coding from the sickbed isn't ideal I suppose :-)