>Randall,
>
>As Rox mentioned, INLIST works.
>In SQL, IN also works:
>
>.... ;
> WHERE MyBank IN ("1234", "5678", "9012").
>
Hi Cindy,
With this syntax could be some problems, unfortunately. Try it by yourself and you'll find them. Ed Pikman was the first, who told me about this. Especially for NOT IN ("1234", "5678", "9012")
>You can also say:
>
>.... ;
> WHERE MyBank IN ;
> (SELECT Bank FROM Banks WHERE Banks.BankType = "SAVINGS")
>
>Thanks for posting the question.
>
>>I have a variable "cBank"
>>
>>I do this to assign things in a case statement
>>
>>cbank = "3850" and so on...
>>
>>I wanta case where the varibale can be either of the things i assign. i.e. - cBank = "0036" or cBank ="3855" or cBank ="3951" or cBank = "3850" or ;
>> cBank = "3950" or cBank = "4369" or cBank = "1778"
>>
>>
>>The variable is in a query as:
>
>SET DEFAULT TO (gc_datapath)
> SELECT nsf.* ;
> FROM nsf ;
> WHERE BETWEEN(nsf.settdate, m.dStartDate, m.dEndDate) ;
> and nsf.portfolio = alltrim(cBank) ;
> ORDER BY bankname, mid ;
> INTO table nsf_return_items.DBF
>
>>I get an Invlid count etc. error. when Ido this. How would I assign this variable in this case?
>>
>>Thanks in advance for your help.
>>
>>Randall
If it's not broken, fix it until it is.
My Blog