| Subject | starting with and like in FB 1.5 |
|---|---|
| Author | Bart Smissaert |
| Post date | 2011-02-02T11:13:27Z |
Is there any difference in Firebird 1.5 between these 2 queries:
field1 starting with 'Z'
field1 like 'Z%'
or are they treated exactly the same internally?
The reason I ask is somebody reckons that like is a lot faster in this
situation.
Bear in mind this is Firebird 1.5.
RBS
field1 starting with 'Z'
field1 like 'Z%'
or are they treated exactly the same internally?
The reason I ask is somebody reckons that like is a lot faster in this
situation.
Bear in mind this is Firebird 1.5.
RBS