How to Find Only Alphanumeric values from column

Question

In SQL SERVER I want to get only alphanumeric values from table column which containing values like given below
i want result like (Rahul@111,123&23,aaa222,@135xyz,#abc)

Rahul@111

123&23

aaa222

@135xyz

#abc

abc

Rupesh Kahane · Answer

@Abhi - Let me know your table values first also please clarify your requirement. so will give you solution

Abhay Shanker · Answer

You want to get only alphanumeric values from table column but the result what have you shown has special characters also.Clarify your requirement.