I'm building a Windows Applicationt to run my business. And I have recently decided to change the way that I search my database of students. I previously search just by the first or last name and I would like to be able to search by part of the name. I have used instr before and when a value greater then 0 is returned then that means it is in the string I'm searching. But I can't figure out why this string doesn't work.
adoPrimaryRS.Open "Select * from StudentINFO where instr(name_first," & "'" & varSearch & "'" & " > 1 order by Name_last", xxxxxxxxxxxxxxxxxxxxxx
Can anyone help me figure this out.