Search results

George, again, thank you. I'm afraid I'm guilty on not posting exactly what my code looks like, but I am using 'name' in the actual code, I just retyped the code, abbreviated in the post, thinking it would be simpler and clearer. I'll refrain from that in the future. I tried the brackets with...

Oops! George, Thank you for responding. The missing quote is just a typo on my part within the posting only. When I got nothing with: SELECT name FROM tbl WHERE name LIKE '%kalaskie%' I guessed that the leading % caused "Kalaskie, David L" to be missed because 'K' is the first letter of the...

I'm experiencing the same problem with VB .NET 2008 objadapter.SelectCommand = New OleDbCommand objadapter.SelectCommand.Connection = DataConnection.GetLRSConn objadapter.SelectCommand.CommandText = _ "SELECT name FROM tblEmployee WHERE name LIKE '%" & _ nameString1 & "%' or name LIKE '" &...