主题：模糊查询的异常

 Dim Filter As String
With e.Form.Controls("用户名")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "convert(varchar,Name) like '%" & .Value & "%'"
    End If
End With
With e.Form.Controls("授权")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "convert(varchar,Group) like '%" & .Value & "%'"
    End If
End With
If e.Form.Controls("Yes").Checked = True Then
    If Filter > "" Then
        Filter = Filter & " And "
    End If
    Filter = Filter & "Incumbency = 1"
End If
If e.Form.Controls("No").Checked = True Then
    If Filter > "" Then
        Filter = Filter & " And "
    End If
    Filter = Filter & "Incumbency = 0"
End If
If Filter > "" Then
    DataTables("Users").LoadFilter = Filter
    DataTables("Users").load()

改成

 

convert(varchar,[Group])