Find Regex pattern exclude alpha numeric

select * from #analysis where value LIKE '%[^0-9A-Za-z]%'

--To remove the extra space use the below code

select * into #regexexcalpnumeric from #analysis where value LIKE '%[^0-9A-Za-z ]%'

--To remove the particular regex characters 

select *  from #regexexcalpnumeric where value not like '%/%' and  value not like '%-%'

and value not like '%.%' and value not like '%)%' and value not like '%:%' and value not like '%\%'

and value not like '%,%'