This will delete all of the records that have more than 1 occurrence including the original.

Function has a bug in it. If the @AppPos is two higher than the last match, the result is incorrect.

Example

select dbo.f_firstposition('abc,def',',',3)

go

Result:4 Incorrect

One Solution - Break when you can't...