Re: [GENERAL] typecast for index

[John Henderson]

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
>
>************
>
>


************