LIKE operation on SYSTEM.DECIMAL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I am having an issue with a dataview.RowFilter expression.

I am trying to filter a dataview with the following:

DV_TXN.RowFilter = "MCC LIKE '" & MCCselection & "'"

But get the following error:
"Cannot perform 'Like' operation on System.Decimal and System.String"

The datatype of the "MCC" column in the oracle table is NUMBER.

Any ideas on how I can filter this??

Thanks in advance!
 
You can create an expression column on your datatable that simply converts
the decimal column to string and you can compare on this new column.
 
Back
Top