Get Extended Character Counts...

[Jason Weibel]

I'm using the following select statement to identify records that contain a non alpha and non numeric character (ex &,/). I would like to modify this script to identify what these characters are and provide a count for each of them. How can this be done? Select LastName, count(*) as 'Counts' From DataTable Where (LastName like ('%[^ a-z0-9]%')) Group by LastName Thank you,