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!

have a look here: 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: