SQLite SELECT problem

no idea

this sample works here

usually this boils down to using a different database file to the one they think they are using.
In fairness, the post says ‘it works if I take out the filter’, but there is something wrong/not being said.

or an error not being reported in the post
lord knows