Different LIKE behaviour between my application and the Access query wizard

by

You are getting tripped up by the difference in LIKE wildcard characters between queries run in Access itself and queries run from an external application.

When running a query from within Access itself you need to use the asterisk as the wildcard character: LIKE '*Ra*'.

When running a query from an external application (like your C# app) you need to use the percent sign as the wildcard character: LIKE '%Ra%'.

More Related Contents:

  1. Using parameters inserting data into access database
  2. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
  3. How to Convert JSON object to Custom C# object?
  4. JavaScriptSerializer – JSON serialization of enum as string
  5. Fire and forget async method in asp.net mvc
  6. Lifetime of ASP.NET Static Variable
  7. Object cannot be cast from DBNull to other types
  8. How to send HTML-formatted email? [duplicate]
  9. How to show a image in database in the image control of Asp.net?
  10. Setting the datasource for a Local Report – .NET & Report Viewer
  11. Can I have an optional parameter for an ASP.NET SOAP web service
  12. Loop through all controls on asp.net webpage
  13. DataTable does not contain definition for AsEnumerable
  14. Upload file on FTP
  15. get date part only from datetime value using entity framework
  16. ASP.NET Identity – Multiple object sets per type are not supported
  17. Convert Dataset to XML
  18. How to add Web API to an existing ASP.NET MVC (5) Web Application project?
  19. Remove columns from DataTable in C#
  20. Check if a folder exist in a directory and create them using C#
  21. Simple JWT authentication in ASP.NET Core 1.0 Web API
  22. IRequiresSessionState vs IReadOnlySessionState
  23. Access files from network share in c# web app
  24. How to convert DataTable to class Object?
  25. call async method without await #2
  26. Find a control in a webform
  27. Can gzip compression be selectively disabled in ASP.NET/IIS 7?
  28. Encrypt Query String including keys
  29. Do we have transactions in MS-Access?
  30. How to get the first five character of a String

Leave a Comment