Why will this "or" staement not work in VB/SQL ADO

From: matthewwhaley@xxxxxxxxx
Date: 3 May 2007 17:20:16 -0700

How do you use the "like / OR" statement in ADO? When I use one
criteria (line 4), it runs fine

sqlstring = "select BusinessName, BusinessID " _
& "from mars.dbo.mroActiveRollups " _
& "where BusinessDate = '4/30/2007' " _
& "AND businessline like '%WB_TREAS' or '%WB_CMG' " _
& "AND rollupID= 2 " _
& "ORDER BY businessline "

.

Follow-Ups:
- Re: Why will this "or" staement not work in VB/SQL ADO
  - From: Bob Barrows [MVP]

Prev by Date: Re: Why does cachesize > 1 skip records?? Bug??
Next by Date: Re: Why will this "or" staement not work in VB/SQL ADO
Previous by thread: Why does cachesize > 1 skip records?? Bug??
Next by thread: Re: Why will this "or" staement not work in VB/SQL ADO
Index(es):
- Date
- Thread