Hello all,



I could note find an information on that subject so far: Is there a way that
SIMILAR TO uses an index? I did not see it so far:



select * from bau2org where ORGANISATIONSEINHEIT SIMILAR TO '01%' - Does not



select * from bau2org where ORGANISATIONSEINHEIT LIKE '01%' - uses index



Motivation: SIMILAR TO would allow more complex queries than like.



Thanks



Niko



[Non-text portions of this message have been removed]