Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types. syntax : PATINDEX ( '%pattern%' , expression )
answered Nov 21 '11 at 11:18 PM
Do you mean the
Or did you mean
I'm guessing, by the way you described it as a function, that you meant the former...