How to use (like ,= operator) with column in Datatable.Select

[Sandy (Sandip Nighot)]

Hi,
I have one column containing both Integer and String value.
And I am using Datatable.Select here I am trying to select data but its showing error
You can not use = operator with string value and If I use LIKE operator it showing error
You can not use Like operator with Integer and String

Thanks,
Sandy

[Pushpak (Pushpak Hegde)]

@Sandy Before comparing the value using = or Like operator, are you concatenating the string value and the integer value together(Converting integer to string). Please share your code snippet of select statement being used.

[nikitha.hanumanthara (Nikitha)]

@Sandy

please chick this code

Datarow=datatable.Select(“column_name='”+String_value+“'”)

let us know if your facing any issue still.

Thank You

[niranjan7988 (Jai Niranjan)]

i faced a problem in similar scenario and I hopefully found a solution. Please refer to the link below

https://forum.uipath.com/t/filtering-a-row-in-datatable/9942