How to use Upper in Select query

Hello

What is the correct syntax for upper[column] in a select from datatable statement?

dataTable.Select(" [Project] =‘123’ and Upper([Active])=‘YES’ ")(“Name”).ToString

I tried with Upper([Active]) but it doesn’t work.

@marius.velicu
refering to the general references Upper is not an available function:

mabye it can done with triggering following:

otherwise we can do it with a LINQ

try this
yourDataTable.Select("[Column-0] = ‘value’ AND [Column-1] = ‘value’").CopyToDataTable

it will remove your case sensitive dependency. it will match the yes & YES record.

Hope it will work

Upper() is not supported in the filter expression.
See https://www.csharp-examples.net/dataview-rowfilter/ for quite comprehensive desription of filter expression syntax.
I would also recommend to use LINQ instead .Select method.

Cheers