the best way compare String

[Rafael Valenzuela]

Hi all,
In one query,  I am comparing a string with a 'like=%patron%', but is very
slow and expensive .What is the best way to compare a string? like or
regular expression?
The data base is too big table 1TB, any idea?
thanks a lot
-- 
Mit forever
My Blog <http://www.redcloverbi.wordpress.com>
My Faborite
Web<http://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm>
http://www.technologyreview.com/