Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

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