Linq replacement for select query

[Amrutha.mg]

DT.Select(" Convert([“+str_CurrentVC+”],‘System.String’) like ‘%“+ str_CurrentSCValue+”%’")
can you suggest me a linq query instead of the above select query please

[kumar.varun2 (Varun Kumar)]

Hi @Amrutha.mg

Try this

DT.AsEnumerable.Where(Function (x) x(str_CurrentVC).ToString.Contains(str_CurrentSCValue)).ToArray

Query version

(From r in DT
Where r(str_CurrentVC).ToString.Contains(str_CurrentSCValue)
Select r).ToArray