[AccessD] Just cannot get this SQL syntax to work

That's it !!!

Only thing is you were off by a single space, but yes, that is it!

To be on the safe side I am going to cover both bases:

SELECT *
FROM tblFilterList
WHERE (((InStr(Replace([Item]," ",""),"[MyField]="))>0));


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

Bill,

Have you tried something like below:
DELETE FROM tblFilterList WHERE InStr([Item],"[MyField]=")>0

Paul

On 24 June 2010 06:03, Bill Benson (vbacreations)
<vbacreations at gmail.com>wrote:

> 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.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com
-- 
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