Hi figuerres!

Thank you for your reply.
The data beeing searched is nvarchar, ntext (without fulltext), datetime, bit, int and uniqueidentifier Smiley.

The system needs to be flexible. If the user can choose from 40 conditions, there should be a solution for 40 conditions Smiley.

The problem is that nvarchar is only 4 000 characters long and the generated SQL is about 10 000 characters long (with 27 conditions).

Thank you.
Stanimir