>Since they both have to search within a character string, they should be approximately equal. Some differences have been reported in the past, but I suspect that the results have been skewed through buffering. You should be careful about this, when you do your own speed tests (the second test on the same data will be faster, because of buffering). > >What is important to note is that none of the two can make use of Rushmore Optimization, i.e., use existing indices to optimize a query.
And neither of them translates out if you ever want to move the query to SQL Server or similar (through SPT).
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry