Convert to Sting and also extract a sub sting in Convert([ColName1],'System.String')

Continuing the discussion from DataTable Select function cannot perform “=” operation on System.Double and System.String:

under For Each of Dt1

Data row = Dt2.Select("(Convert([ColName1],‘System.String’).SubString(5).) like ‘%"+row(“ColName1”).toString.Replace("*","")+"%’ ")

Where the Sub string extraction is not possible. please advice.

Hi @AvinashRavi

try this
an example
Dt2.Select("[ColumnName1] like +StrText.ToString.Substring(5)+").CopyToDatatable

Thanks
Ashwin S