Need help in ms access query using vb.net

See more:

VB

Hi guys,

i am having trouble in my program , i want to search the database if it has the word/phrase on the string i typed in. if it was there it will be shown through messagebox else prompt that there isnt. i tried using LIKE in my query but it only search the database that contains the string i typed. i want it to be the opposite...

this is my code i know its horrible please help.

Public Sub searchSpecial(ByVal UserInput)
     conn.ConnectionString = c_string_special
     conn.Close()
     Dim cmd As New OleDbCommand
     Dim dr As OleDbDataReader
     If conn.State = ConnectionState.Closed Then
         conn.Open()
     End If
     With cmd
         .Connection = conn
         .CommandText = "SELECT * FROM fear WHERE sentence LIKE '% %'"
         .CommandType = CommandType.Text
         dr = .ExecuteReader
     End With
     If dr.Read() Then
         Dim x = dr.Item("sentence")
         If x.ToString.Contains(UserInput) Or UserInput.ToString.Contains(x) Then
             MsgBox(UserInput)
         End If
     End If
     conn.Close()
 End Sub