Hi Everyone,
I'm using the database class from
http://www.codeproject.com/KB/database/csharpaccessdb.aspx
and for the most part it has worked exactly how I want, which is great.
I came across a problem when one of my queries uses the LIKE '*' condition. For some reason, whenever * is used, it doesn't work.
Let me give an example...
SELECT Title FROM Books WHERE Title LIKE 'Tomorrow, When The War Began';
WORKS in Access and C#
SELECT Title FROM Books WHERE Title LIKE 'Tomorrow*';
Works in Access, but not in C#
I can't seem to find out why the * doesn't work. I got to the stage where I was copying the query directly from a working Access query where it returns the correct results, but when I put it in C#, it just doesn't work. Every other query that doesn't involve LIKE '*' works in C# with the exact same results as Access, so there isn't a problem connecting to the database.
If there are any suggestions, that would be a great help!
Thanks,
Josh.