Check if value is Alphanumeric or not SQL Server

Hi makumbi,

Please refer below Query.

SQL

SELECT CASE WHEN c1 NOT LIKE '%[^A-Za-z]%' THEN 'Not Alphanumeric'
ELSE 'Alphanumeric' END 'Status' 
FROM
(
	SELECT 'abc' AS c1 UNION all
	SELECT 'a1bc' UNION all
	SELECT '123' UNION all
	SELECT 'a!bc' UNION all
	SELECT 'a1bc#' UNION all
	SELECT '12^3'
) AS T

Output