I believe Access does not have the
LIMIT keyword, and that is only an extension specific to MySQL. MS SQL Server uses
TOP but I don't think Access has this function. Also, Access and MS SQL Server uses square brackets (
[]) to delimit its variable names, while MySQL uses the backtick (
`). Other than these issues, the
LIKE operator would settle your string searching needs.
For case-insensitivity, first of all, I do not know if this function is available in VB because all I've used is VB.NET. Note the underlined portions:
Dim searchText as String
Dim sqlQuery as String
searchText = searchDescription.Text
sqlQuery = "SELECT * FROM [whatever_table] WHERE TOLOWER([description]) LIKE `%" & searchText.ToLower() & "%';"
When you set both the field you are matching with and the match text to lowercase (or uppercase), it is equivalent to a case-insensitive match, albeit the possible inefficiency of matching long strings of opposite-cased text.
You might want to take a look at this two posts for some issues related to this:
http://www.daniweb.com/techtalkforums/post200141-5.html
http://www.daniweb.com/techtalkforums/post200190-9.html
Hope this helps
Unsolved 
