[AccessD] Just cannot get this SQL syntax to work

Correction ... 

-----Original Message-----
From: Bill Benson (vbacreations) [mailto:vbacreations at gmail.com] 
Sent: Thursday, June 24, 2010 12:51 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: Just cannot get this SQL syntax to work

Let me point out that my table has these values for Item

   [MYFIELD] = "ABA"
   [MYFIELD] = "ABERDEEN"

And even a queries such as 

SELECT * 
FROM TblFilterList
WHERE [Item] LIKE '[A*'



--- OR ----

SELECT * 
FROM TblFilterList
WHERE [Item] Like "[A*"


Do not tease out any records.