[AccessD] using Like with ODBC

Hi Drew,
Well that worked
I already tried that but must have had a typing error in there somewhere..
Many thanks
Robin

----- Original Message ----- 
From: "Drew Wutka" <DWUTKA at marlow.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Tuesday, May 10, 2011 6:57 PM
Subject: Re: [AccessD] using Like with ODBC


> If you are using ADO, the problem probably isn't like, it's *, ADO uses
> % instead of the asterisk.
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robin
> Lawrence
> Sent: Tuesday, May 10, 2011 12:52 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] using Like with ODBC
>
> Hi All
>
> I'm connecting to a Sage Line 50 Accounts program via ODBC and need to
> do a
> multiple LIKE selection from Access XP
>
> ie in the query criteria
> [Status]
> LIKE "*sold*" OR LIKE "*returned*" OR LIKE "*finished*"'  but am getting
> a
> syntax error from the ODBC driver
>
>
> Been a while since I've had to do this - can't remember the workaround,
> any
> help greatly appreciated.....
> TIA
>
> Robin Lawrence
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> The information contained in this transmission is intended only for the 
> person or entity
> to which it is addressed and may contain II-VI Proprietary and/or II-VI 
> Business
> Sensitive material. If you are not the intended recipient, please contact 
> the sender
> immediately and destroy the material in its entirety, whether electronic 
> or hard copy.
> You are notified that any review, retransmission, copying, disclosure, 
> dissemination,
> or other use of, or taking of any action in reliance upon this information 
> by persons
> or entities other than the intended recipient is prohibited.
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com