Rick Roen <[EMAIL PROTECTED]> writes: > > I'm not sure if this would entirely solve your problem, but can you use > "Starting with". > > Apparently this is what the fb db engine maps "Like" to internally since > Starting with will use an available index and Like not. > > Rick >
Thanks for trying to help Rick, I really appreciate. You're right, LIKE 'xxx%' OR Starting with 'xxx' both generate the same execution plan. Unfortunately, there are situations where starting with doesn't fit my needs. Thanks again. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
