I am trying to do a select * from table where column like '%pattern%' ;
from a varchar field, and am getting the error:
RestrictionClauseSelectivity : bad value - 1.98625 error .
I am at a loss to figure out why the select is failing.
Any help appreciated.
--
Danny Aldham Providing Certified Internetworking Solutions to Business
www.postino.com E-Mail, Web Servers, Web Databases, SQL PHP & Perl