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 -- http://mail.python.org/mailman/listinfo/python-list