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 Thu Nov 20 2003 - 20:44:19 CST
