SQL = "SELECT * FROM TICKETS WHERE"
 
        If DropDownList3.SelectedValue.Length > 0 Then
            SQL += _
                " Status = '" & DropDownList3.SelectedValue & "'AND "
            set_and = True
        End If
 
        If DropDownList4.SelectedValue.Length > 0 Then
            SQL += _
            " SubStatus = '" & DropDownList4.SelectedValue & "'"
        End If
 
        If SR.Text.Length > 0 Then
            SQL += _
            "AND 'SR = " & SR.Text & "'"
            set_and = True
        End If
 
        If SoftwareVersion.Text.Length > 0 And set_and = True Then
            SQL += _
            " AND SoftwareVersion = '" & SoftwareVersion.Text & "'"
            set_and = True
        End If