Recent content by wfs

it appears that Access 2003 is intrinsically case insensitive (?) - so I converted everything to upper case (that was the intended plan anyway - I just hadn't bothered to get round to it up until that point...) SELECT * FROM T_TEST where FIRST_NAME like 'Jo%' this works from an OleDb or...

Hi All, I'm tring to perform various queries against an Access 2003 database from a C# app via OleDB. The 'standard' SQL syntax doesn't seem to work ? For instance if I have a table; First_Name ------------- JOHN John SELECT * FROM T_TEST where FIRST_NAME like 'Jo%' - returns no rows...