To handle case sensitive in SELECT query in uipath

Help
1

My query like this Dt.Select(“Convert([CustomerID],System.String)='”+row(“Id”)+“'”).CopyToDataTable

Here row(“Id”) will be ROBOT123
but in my datatable is robot123

how to handle this

2

change the = sign to a LIKE

3

Is like accepts case sensitive

4

like is INSENSITIVE and = is SENSITIVE…

5

cant get u friend can you please rewrite the code i’ve given

6

Dt.Select(“Convert([CustomerID],System.String) LIKE ’”+row(“Id”)+“’”).CopyToDataTable

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.