MSSQL LIKE and IN statements in ADO problem

gregarican greg.kujawa at gmail.com
Wed Jan 18 11:38:29 EST 2006


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?




More information about the Python-list mailing list