How to use LIKE and = Operator in DataTable.Select()

When I use datarow = dataTable.Select("[ColumnName] LIKE ‘%String%’") I met the error is: Can’t use LIKE operator to System.Double and System.String.
How can I fix them?
Helpme please!

@Quang_Th_nh_Nguy_n
have a look here:


https://www.csharp-examples.net/dataview-rowfilter/ for the general syntax

as it has taken two different datatypes for the comparing give a try on:
dataTableVar.AsEnumerable.Where(Function(r) r("ColumnName").ToString.ToLower.Contains(yourStringVar) ).toList

and apply following pattern for handling a possible empty result, just adopt the variable names to your used names: