Thank you for your reply.
The data beeing searched is
ntext (without fulltext),
The system needs to be flexible. If the user can choose from 40 conditions, there should be a solution for 40 conditions .
The problem is that
nvarchar is only 4 000 characters long and the generated SQL is about 10 000 characters long (with 27 conditions).