Is it just me or does the like operator not work with the sun.jdbc.odbc.JdbcOdbcDriver. String sql = "SELECT * FROM test WHERE name like '*wal*' order by name;"; When this is executed in my java code no results are returned. When executed directly within Access the correct results are displayed. Anyone else experienced the same problem. Does anyone have a like operation that works via jdbc? Thanks.
Joined: Apr 04, 2002
Sorry folks, I figured it out. Although * is the MS Access wildcard the jdbc driver expects % not *.
I just deleted a post seconds ago in which I said "wildcards in SQL are % and _". Deleted it because I looked up wildcards in Access help and saw that Access does use * and ?. (Go figure.) Good that you solved the problem.