MSSQL LIKE and IN statements in ADO problem

Raja Raman Sundararajan ram0812 at
Thu Jan 19 09:02:28 EST 2006

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.

/Raja Raman

More information about the Python-list mailing list