LIKE operation on SYSTEM.DECIMAL

[ksedran]

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

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

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"ksedran" <ks*****@discussions.microsoft.com> wrote in message
news:A6**********************************@microsof t.com...

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

[Cor Ligthert]

To add a little bit to the text from Bill.

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.

You can create an extra column in your datatable. Direct with that command
you can use the expression to fill the data that than converts the decimal
column to string. Than you can compare on this new column.

By the way, did you know that there are newsgroups
microsoft.public.dotnet.framework.adonet
microsoft.public.dotnet.languages.vb

That are newsgroups more specialized on questions like this, where for this
question the first one is in my opinion the right one.

Cor