我想以输入某个特定字符然后以字符分割,like运算包含的每一段分割的字符,代码要如何写?我以下不能成功
If ff.Value IsNot Nothing Then
If ff.value.Contains("|") Then
Filter = Filter & " and " & "货期 In ('" & ff.Value.Replace("|","','") & "')"
ElseIf ff.value.Contains("@") Then
Filter = Filter & " And " & "(货期 Like '%" & ff.Value.Replace("@"," & "%' or 货期 like '%" & ") & "%')"
Else
Filter = Filter & " and " & "货期 like '%" & ff.Value & "%'"
End If
End If
加好友 
发短信
Post By：2020/3/27 9:29:00 [显示全部帖子]
