Hi Himlar

Had just got to this one, but unfortunately it doesn't completely resolve my problem, which is that I want to do create a view to do this with dynamic user defined data (ie. the decide what is in the list.

This would normally be fine using macro substitution but I need to do this with a remote view and this is not permitted.

Any ideas how I can get around this?

Regards
Geoff

>inlist() is quite a bit shorter, and should be optimizable:
>
>

>... where inlist(Status, "A", "F", "T", "H", "E", "W")
>
>>Hi
>>
>>I have a large table with a status field and I want to select the records for a group os status's.
>>the table is indexed on the status
>>
>>this can be done by
>><pre>lcStatusList = 'AFTHEW'
>>SELECT* ;
>>FROM mytable ;
>>WHERE mytable.status $ ?lcStatusList

>>
>>Unfortunately, this does not optimize.
>>
>>Is there any way to fully optimize this query without expanding the Select to something like
>>
>>

SELECT* ;
>>FROM mytable ;
>>WHERE mytable.status = 'A' OR ;
>>	mytable.status = 'F' OR ;
>>	mytable.status = 'T' OR ;
>>	mytable.status = 'H' OR ;
>>	mytable.status = 'E' OR ;
>>	mytable.status = 'W'

>>
>>regards
>>Geoff Scott