Sorry forgot to explain that with the string substitution stuff you can escape the percent sign by doubling it up. In my example I wanted to retain the leading percent sign before the value, in this case I wanted LIKE %raj to appear. So I doubled it up. That's why there are three percent signs in a row. The last one is the one associated with the string substitution for the name variable. Make sense?
-- http://mail.python.org/mailman/listinfo/python-list
