Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
DBISAM Technical Support
»
Support Forums
»
DBISAM SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
like without wildcard
Fri, Dec 29 2006 10:00 PM
Permanent Link
"Jerry Hayes"
Is there a reason why select * from names where lname like 'SMITH%' is fully
optimized, but lname like 'SMITH' is not? Just curious here.
Tue, Jan 2 2007 2:05 PM
Permanent Link
Tim Young [Elevate Software]
Elevate Software, Inc.
timyoung@elevatesoft.com
Jerry,
<< Is there a reason why select * from names where lname like 'SMITH%' is
fully optimized, but lname like 'SMITH' is not? Just curious here. >>
Not really, probably just an oversight. I'll add this to the list for the
next build.
--
Tim Young
Elevate Software
www.elevatesoft.com