>Did you try something like:
>

>SELECT .. WHERE myField = MyPar or MyField LIKE myPar + '%'

>
>Was the speed better?

No, this doesn't change anything. To support this parameterized approach in regards to performance issue, I will have to use the text indexation as described by Rick. When I do it by putting the value as is in the SQL, it is an immediate result. So, because everything is parameterized, in order to avoid this downsize effect, I will look into the text indexation.