can u tell me how to find a part of string using an sql..
Dim inp As String
inp = InputBox("Enter the Search Term")
exec ("select * from solution_database where search_term like '" + inp+ "' ")
i want to get the records whose search_trem contains the string "inp" which is a part of search_trem(a column in my table)
i'm not able to use inp*
can u plz tell me