Werner, I think you should try
> SELECT GAS.ObjectType.ID, GAS.ObjectType.NameDe FROM GAS.ObjectType
> WHERE (
> :ObjectType IN GAS.ObjectType.TypeTree
GAS.ObjectType.TypeTree IN :ObjectType
Now that I type it... Three periods in a table name? Wouldn't that be
GAS.ObjectType->TypeTree instead? :)
This is going to work if ObjectType is either a single or (I guess) a
comma-delimited value. This particular tidbit has been discussed before.
HTH,
Ram�n
