I am trying to do a comparison like below and somehow it is not working. Is it because I am trying to compare a value assigned to a variable with the string. How can I fix that?
please help. thank you
please help. thank you
Code:
If String.Compare(strStates1, "ALL", True) = -1 Then
.Append(" AND R.STATE IN (SELECT * FROM TABLE (CAST (func_select_state (:BindStates) AS B_state)))")
cmdDBEVendors.Parameters.Add(New OracleParameter(":BindStates", OracleDbType.Varchar2)).Value = strStates1
End If