>Hi,
>
>I have a place in the program where the SQL Select (that selects records for a Cursor Adapter) is built dynamically as follows:
>
>

>select * from MyTable where OrderNo in (Number1, Number2, .... )
>

>
>The part in parenthesis is built dynamically and the user can select pretty much any number of order numbers to include. So if the entire SQL Select becomes too long, it bombs. Any suggestions on how I could simplify this but still allow user to select any number of "orders"?
>
>TIA

Easiest solution is to count the words and split with or

where orderno in (1,2,3,4) or orderno in (5,6,7,8)