>If you still want to use TOP clause you may use derived tables, e.g.
>
>select top 100 from (select ....) order by ...

Yes, good point, it still irritates me however that that clause is causing such an effect when being used with the % character on only specific fields.