LIKE operation on SYSTEM.DECIMAL

[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!

 

[W.G. Ryan eMVP]

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.