PYODBC Connection Cursor using LIKE statement not working

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Connect to a MS Access 2007 Database 
2.Execute a connection cursor using the WHERE [fieldname] = 'value';
3.Execute a connection cursor using the WHERE [fieldname] LIKE 'value*'; 
statement

What is the expected output? What do you see instead?
For the = statement query - i get over 500 rows back, but the like statment 
using the same table and same field/value pair - i get 0 rows back.  This 
should give me the same number of rows if not more because of the like statment

What version of the product are you using? On what operating system?
I am using Python 2.6, MS Access 2007, and pyodbc module 2.1.8

Please provide any additional information below.
I am not sure if the "LIKE" part of this is not working or not avaiable.  I 
figured as long as my SQL string was formed correct it would work.  Below are 
my 2 full SQL statments. 

EQUALS statement (returns 555 rows)
"SELECT DISTRICT, PROBLEM2, STATUS2, OPEN_CATAGORY, OPENING_ID FROM 
priority_problems WHERE STATUS2 = 'DN';"

LIKE statement (returns 0 rows)
"SELECT DISTRICT, PROBLEM2, STATUS2, OPEN_CATAGORY, OPENING_ID FROM 
priority_problems WHERE STATUS2 LIKE 'DN*';"

Thanks

Original issue reported on code.google.com by darryl.k...@gmail.com on 18 Jan 2012 at 6:00

[GoogleCodeExporter]

I found a partial answer to this problem.  Using the LIKE Statment with the 
PYODBC connection - you must use a '%' as a wildcard.  Although the '%' 
wildcard doesn't work when executing a SQL statment in Access manually.  This 
is very strange why the wildcard value changes in the 2 SQL statments.  '*' 
works in Access SQL and '%' works in PYODBC SQL.

Original comment by darryl.k...@gmail.com on 18 Jan 2012 at 6:25

[GoogleCodeExporter]

This is normal.  The correct wildcard is '%', but Access changes it when using 
the Access UI.

Original comment by mkleehammer on 23 Jun 2012 at 9:47

• Changed state: NoFix

[GoogleCodeExporter]

Hi, can you help me?
This code works for me:

cursor.execute("SELECT Zadání FROM tab1 WHERE Zadání Like '%something%';")

But this one doesn't work, and i don't know why.

X='%something%'
cursor.execute("SELECT Zadání FROM tab1 WHERE Zadání Like ?;",X)

Am i doing something wrong?
Btw, great work with that module, you save my school project. ZIZA

Original comment by jakub.zi...@seznam.cz on 28 Apr 2013 at 5:41

[GoogleCodeExporter]

Not sure what you are trying to do with the ?;" 
But I think you want to try this instead
X = '%something%'
cursor.execute("SELECT Zadani FROM tab1 WHERE Zadani LIKE %s;" % X)

Original comment by darryl.k...@gmail.com on 28 Apr 2013 at 11:32

[GoogleCodeExporter]

Yeah, that is what i meant, it works now, Thank you very much for your time.

Original comment by jakub.zi...@seznam.cz on 29 Apr 2013 at 2:08

[GoogleCodeExporter]

The "?" is a placeholder for cursor to sanitize inputs from SQL injection 
attacks I believe, so switching to "% X" could possibly open up a vulnerability.

Original comment by dhel...@gmail.com on 16 Dec 2013 at 9:40