I can't find anything in the help file about how the % wildcard affects optimization. It may be worth doing some experimenting.
Perhaps I'm too superstitious, but I will do just about anything to avoid
SET EXACT ON
Guy
>>I didn't realize that this was part of an SQL statement. The quick answer is: "I don't know."
>>
>>But if I understand you to be using this in a SQL statement then I am confused about why you don't just use
>> 'MICHEL' >= 'M'
>>
>>What exacty are you doing?
>
>The sample was taking from that approach:
>
>
>SELECT * FROM LISTCLASSIFI WHERE UPPER(LISTCLASSIFI.SOFTWARE)>='A' ORDER BY SOFTWARE
>
>
>To make it work, SET EXACT must be on.
>
>I can also make it work with % but I want to be sure that it won't affect the optimization.