MSSQL LIKE and IN statements in ADO problem

[Peter A. Schott]

Well, the raw TSQL would be:

select * from tb_name where firstname like '%raj%'

I think that would more translate to:

name = "raj"
cmd.CommandText = "SELECT * FROM tb_name WHERE firstname like '%%%s%%'" % name

Perhaps issuing a print statement of the CommandText would help for future runs
to determine if this is valid TSQL syntax?

-Pete

"gregarican" <greg.kujawa at gmail.com> wrote:

> Can't you get rid of the Create Parameter part and directly pass along
> the value you are looking for? Something like...
> 
> name = 'raj'
> cmd.CommandText= \
>         "SELECT * FROM tb_name WHERE firstname LIKE %%%s" % name
> 
> This way the value of the name variable gets passed along when the
> CommandText method is invoked. BTW, this looks too painfully much like
> Visual Basic than Python :-) Just kidding (kind of)