To handle case sensitive in SELECT query in uipath

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

change the = sign to a LIKE

Is like accepts case sensitive

like is INSENSITIVE and = is SENSITIVE…

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

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

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