I'm still learning the purpose myself (I've only been here for 6 months and this is a new process for me). Our company was kind of a garage-startup many years...

Wow, thanks Chris! I can't believe I forgot to N' the string. That single oversight fixed the entire routine.

Good information to know on the CHAR/Unicode/ASCII differences. I've never had to...

A little more testing and it looks like it might really be a collation issue. If I comment out the following, the return comes back as I expect.

SET @loop =...

I thought supplementary char collations were not in 2k8? When...

Unfortunately, converting to varbinary didn't work and neither did removing the nchar(0) start.

Also unfortunately, I do not have permission to run profiler in this particular case. It's a severely locked...

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...

Basically, I think what is happeneing is that the dynamic SQL is evaluating '?' as one of my invalid characters, even though it's not part of my list. '?' is...