• PATINDEX is a function, whereas LIKE is a predicate.

    --
    Adam Machanic
    whoisactive