I spent (too many) hours today trying to figure out why I couldn’t get a query to run through ADODB from an HTA I’m working on.  The query pulls from a linked table which links to a tab-delimited text file, and the query had a WHERE condition as such:

WHERE field1 LIKE "00*"

Apparently, I wasn’t doing anything wrong, but the query keep returning empty.  Only when I changed the WHERE clause to

WHERE field6 Is Not Null

did I get the expected results. I don’t know what to think of that, but it’s a good thing to remember.

I was using ADODB to run a query from MS Access, btw.