Identify illegal characters

An interesting recursive CTE to list out the non-alphanumeric characters in a column of a table.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.75 (4)

You rated this post out of 5. Change rating

2012-05-08 (first published: 2012-04-12)

2,968 reads

Blogs

I wanted to figure out how big (or approximately how big) my dump file...

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

I have a table. Structure in script below. I have to compare and see...

I have an application team that is insisting on daily (and for some, weekly)...

i see this in the definition of a linked server on our wh sql...

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';