I had the general idea right, just the implementation wrong.
Try this:
SELECT
*
FROM
#frUser_Copy
WHERE
[UserName] LIKE '%[^a-z0-9]%'
Unless you have a case-sensitive collation then the a-z will work for any alpha characters including upper-case
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question