> to return 'WHERE name LIKE %smith%' I have tried using escapes, > character codes for the % sign, and lots of other gyrations with no > success. The only thing that works is if I modify searchterm first: > > searchterm = 'smith' > searchterm ='%'+'smith'+'%' > sql += 'WHERE name LIKE %s' % searchterm > > Any Ideas?
>>> "%%%s%%" % "here you go" '%here you go%' Cheers, - harold - -- If your only tool is a hammer, every problem looks like a nail. -- -- http://mail.python.org/mailman/listinfo/python-list
