How you're constructing your select statements? If you select multiple values, are you using myValue IN (myvalue1, myvalue2, ...) May be you need to create temp tables with these values on the fly. This is how we solved the similar problem.

>I wish. < g > This is in our reporting app. The select string is built off what the user wants to see. I am not sure how to split it or cut it. The main problem, I thought this morning, was going to be getting the memo fields into the select, but I fixed that with a small function that puts an alltrim() around those fields if in the select fields area. Then I ran into this.
>
>Guess I will go home and think on this tonight. Then see if anyone has a different idea after trying mine.
>
>Thanks
>
>>
>>Can you cut that string?
>>Or split it to two different selects?