What steps will reproduce the problem?
1. This query in pyodbc fails (finds no records)
cursor.execute('SELECT Record, Cue '
'FROM Songs '
'WHERE Cue IS NOT NULL '
"AND Cue <> '' "
'ORDER BY Record')
2. This query in MS Access works:
SELECT Record, Cue
FROM Songs
WHERE Cue IS NOT NULL
AND Cue <> ''
ORDER BY Record;
3. The Cue field is Long Text, containing XML.
What is the expected output? What do you see instead?
I expect 1849 records. I see 0.
What version of the product are you using? On what operating system?
Python 2.7 pyodbc-3.0.7 on windows 8 64 bit, but using 32 bit python