Using SQL Like RRS feed

  • Question

  • I have been trying to get the SQL Like to work, but can not.  I am writing the SQL query in the VB program, and opening the Access 03 database and running the query against the data.  If I copy the query that the program has made, and open the Access 03 database and create a new query and paste it into the form and run it...it works like its supposed to.  Any help would be appreciated.
    Friday, July 6, 2007 2:38 PM

All replies

  • Moved from VB Language forum.

    Post the query that works along with the query that does not work.  The wildcard character for a LIKE clause in Access is * while in SQL it is %.  There are other syntax differences that may be causing you a problem.
    Friday, July 6, 2007 4:44 PM