Lowell,
Sadly, this isn't matching any rows:
select id, name
FROM my_user_table
WHERE CHARINDEX(name,CHAR(0),1) > 0
No rows returned. Likewise, the replace operation doesn't touch any of the rows. Ideas?
Thank you very much for the help you've provided thus far. I feel like I'm on the verge of clobbering this beast thanks to your assistance!
mtf