LIKE problem

[klapy]

What I want to do is insert all old entrys of a certain table into another table...I tried a lot of things, nothing works.Something like this should work, but it doesnt.SELECT *FROM tblAVWHERE tblAV.[Datum uitleen] LIKE '%2006';Date is formatted like: d/m/y and I want to move ALL entry's of a certain year to another table.

[aspnetguy]

You should avoid having spaces in column names.

WHERE tblAV.[Datum uitleen] LIKE '%2006';

[pulpfiction]

Try this, i guess it should work....SELECT * FROM tblAV WHERE Year(tblAV.[Datum uitleen]) = 2006;