The script works fine and properly if I do not build a dynamic SQL input, but it also doesn't actually parse out the @Pattern prior to the PATINDEX in the static query like it does in the dynamic SQL.

I did go ahead and try other collations, though, with the same result. Any idea what collation would accept the unicode extended characters?