Subject Re: [IBO] "starting with" clause
Author Helen Borrie
At 02:42 AM 28/06/2003 +0000, you wrote:
>What is this "starting with" clause? Its the first I have seen that
>clause is that for IBO use only or it is a standard sql clause?

It's standard SQL. In Firebird/InterBase, STARTING WITH 'astring' is
equivalent to LIKE 'astring%' - both will use indexes for fast
searching. (LIKE doesn't otherwise use indexes at all...)