| Subject | Re: [IBO] "starting with" clause |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-06-28T04:54:46Z |
At 02:42 AM 28/06/2003 +0000, you wrote:
equivalent to LIKE 'astring%' - both will use indexes for fast
searching. (LIKE doesn't otherwise use indexes at all...)
Helen
>What is this "starting with" clause? Its the first I have seen thatIt's standard SQL. In Firebird/InterBase, STARTING WITH 'astring' is
>clause is that for IBO use only or it is a standard sql clause?
equivalent to LIKE 'astring%' - both will use indexes for fast
searching. (LIKE doesn't otherwise use indexes at all...)
Helen