Which one is faster?

I have a string of thousands of characters and I want to check if it ends with '>>' There are 2 ways of doing it ( or more maybe)

If big_str like '%>>' Then

OR

If substr(big_str , length(big_str) - 1 , 2 ) = '>>' Then

Which one is faster? obviously the 1st one is simpler.

Or is there a better way?

thx Received on Tue Jul 06 2004 - 23:32:24 CDT