First I used the replace to find which were the undesired chars.

Next I used the replace to get rid of the undesired chars.

(Maybe a next step would be to use replace to replace all 'c' with a 'k', to make some text like 'disc' and 'disk' the same. And maybe I'll remove all double characters to get even more matches.).

I do not see how I would do that with the PATINDEX function.

I can only see complex solutions when using the PATINDEX for this problem. But maybe I am missing something:(. (Sorry for that).

Thanks for your response,

ben brugman