string formatting using the % operator

[Peter Hansen]

Dan Sommers wrote:
> Let the DB-API do more work for you:
> 
>     cursor = connection.cursor( )
>     sql = """SELECT column2, columns3 FROM table WHERE name LIKE %s"""
>     values = ('%%%s%%' % searchterm,) # note that this is a tuple

It looks like this might be a rare case where not using the % operator 
might make it easier to see what's going on:

       values = ('%' + searchterm + '%',)

-Peter