Thank you Ed,
>IIRC, this is a known issue with 'IN', and that the traditional
>solution was to replace use of 'IN' with 'EXISTS', i.e.,
>
> and EXISTS (select * from userdir where user_name = username and
>towncode...)
>
>Cheers,
>Ed Loehr
>
>************
>
>