I try to do a filter for SQL search. I have a database with columns id,remarks and date. Date column datatype is datetime. What i want to do is using LIKE statement to filter the search. Its like
where date like '%2016%'
Dim Query = From apt In dbb.apt
Select apt.id, apt.remarks, apt.date