SELECT * FROM TBLDATA WHERE ([Event Date] LIKE '8/08/2006*');

##</code><code>##

SELECT * FROM TBLDATA WHERE ([Event Date] = #8/08/2006#);