• FYI, I posted my own test results here, along with an invitation for someone to show me how to prove that PATINDEX will, indeed, outperform LIKE:

    http://sqljunkies.com/WebLog/amachanic/archive/2004/11/08/4993.aspx

    --
    Adam Machanic
    whoisactive