[AccessD] Just cannot get this SQL syntax to work

Bill Benson (vbacreations) vbacreations at gmail.com
Wed Jun 23 23:50:35 CDT 2010


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 '[M*'



--- OR ----

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


Do not tease out any records.




More information about the AccessD mailing list