Re: Select this or ALL.

From: Prince Of Thieves <thief_NOSPAM_at_hotmail.com>
Date: Fri, 21 Nov 2003 17:15:06 +1100
Message-ID: <3%hvb.107$GB2.3843@nnrp1.ozemail.com.au>

But can it be done with one variable? How do I say "Select ALL" using the variable? I tried:

var DivCode = "*"

but that didn't work.

-- 

Julian Milano


"Hans Forbrich" <forbrich_at_yahoo.net> wrote in message
news:3FBD7C5A.4A12AF71_at_yahoo.net...


> Prince Of Thieves wrote:

> >

> > I have the following line in my SQL:

> >

> > and divn.code= :DivCode

> >

> > DivCode normally is set to:

> >

> > -- var DivCode = "CORPORATE"

> > -- var DivCode = "DAVENPORT"

> > -- var DivCode = "LIFESTYLE"

> > -- var DivCode = "SPORT"

> > -- var DivCode = "VIRGIN O/WEAR"

> > -- var DivCode = "VIRGIN U/WEAR"

> >

> > How can I change the line so that it either takes a value, as above, a

> > combination of the above (maybe two or three of the above together or

ALL of


> > the above?

> >

>

> Several variants.  The easiest to understand - check out subselect, 'OR'

> and 'IN' in the docco.

Received on Fri Nov 21 2003 - 00:15:06 CST