[AccessD] Just cannot get this SQL syntax to work

No problem, glad to be of help.  I rarely get time to help with questions
and this list has helped me immmensely over the years.

Paul

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

> 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
>
>
> --
> 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