Dim strSQL As String = String.Empty
strSQL = " SELECT * FROM table_name WHERE 1=1 "
IF strCondtion1 <> String.Empty Then
strSQL = strSQL & " AND column LIKE '% " & strCondtion1 & "%' "
End IF
IF strCondtion2 <> String.Empty Then
strSQL = strSQL & " AND column LIKE '% " & strCondtion2 & "%' "
End IF