asked
what is the use of padindex function
what is the use of padindex function , when and where can be used ?
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 )
I'm confused. Do you mean the `PATINDEX` function, which, as @viikiseth has indicated, is for string pattern matching - see also Or did you mean `PAD INDEX`, which you can use to tune index performance - see I'm guessing, by the way you described it as a function, that you meant the former...
