Using asterisks in comparison

Hi, I have a code like this:
db_in.Select(“[VALUE] <> ‘ “ + var1 + ” ’“).CopyToDatatable()

Given that I have a list of numbers, let’s say 10000, 10001, 10002, 20001, 20002, 20003. I’d like to select only the variables that do not start with 2 (and 2 is defined in a variable). How do I go about changing my code? I’ve tried LIKE but been told that it’s text only (?) and either way I cannot get it working. Any tips?

Hi @mickeymack,
You can use filter data table activity here.

Filterdt.xaml (7.1 KB)

Unfortunately no, I cannot. This is just part of the code, I also use comparisons with variables containing multiple values, something that FDT doesn’t support.

Hi Mickeymack, we can add multiple conditions in row filter and have different operators. Please try else you need to write some custom code in your WF.

I have a variable named “Account” that contains five values. I cannot use Filter Data Table on this since there are no “IN” operator that works in Filter Data Table.


Try this.

    db_in.Select("[ColumnName] NOT LIKE '2%'").CopyToDataTable