[AccessD] Just cannot get this SQL syntax to work

Steve, able to use what you started me out with to nail this

Like "[[]MyField] =*" Or Like "[[]MyField]=*"

Thanks!!!!


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Thursday, June 24, 2010 1:02 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Just cannot get this SQL syntax to work

Hi Bill,

No, for that one you would need:

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

Regards
Steve


--------------------------------------------------
From: "Bill Benson (vbacreations)" <vbacreations at gmail.com>
Sent: Thursday, June 24, 2010 4:50 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] 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 '[M*'
>
>
>
> --- OR ----
>
> SELECT *
> FROM TblFilterList
> WHERE [Item] Like "[M*"
>
>
> Do not tease out any records.
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.829 / Virus Database: 271.1.1/2957 - Release Date: 06/23/10
02:36:00