Recent content by wfs

  1. W

    SQL Question - OleDB from C# Application

    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...
  2. W

    SQL Question - OleDB from C# Application

    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...
Back
Top Bottom