InterBase LIKE pretty fast

I recently needed to build a search engine using Delphi and InterBase 7.

At first, I thought I couldn't use the InterBase LIKE search method, since I had the impression that it was slow. It turned out to be the other way around!

Also, the new ROWS clause in the SELECT statement helps limiting the results of the query.