Hello,

I am using a sql server database and I have a smallint field. I've used the code below successfully whenever I'm searching for char data. But I get an error when I try to search for integer data. My error is 'Find cannot be performed over the specified column or compare operator is invalid.'

Here is my code:

HTML Code:
Dim SearchValue As Integer
Dim SearchField As String
    
    Select Case cmbSearchField
        Case Is = "Trunk Number"
            SearchField = "TrunkNumber"
        Case Is = "Trunk Group Number"
            SearchField = "GroupNumber"
        Case Else
            MsgBox ("You must select a valid search field.")
            Exit Sub
    End Select
    
    SearchValue = InputBox("Enter your search value:", "Database Search")
    
    If Trim(SearchValue) = "" Then
        'do nothing
    Else
        With Adodc1.Recordset
            .Find (SearchField & " Like '%" & SearchValue & "%'")
            If Adodc1.Recordset.EOF Then
                MsgBox ("Record could not be found.")
            End If
        End With
    End If
Any ideas why I am having trouble with integer data?

Thanks, Stephanie