Link to home
Start Free TrialLog in
Avatar of Rupesh Mishra
Rupesh Mishra

asked on

How to remove numeric and alpha from an alphanumeric field?

How to remove numeric and alpha from an alphanumeric field?
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Nakul Vachhrajani
If you remove both numeric and alpha data from an alphanumeric field, you would be left with nothing.

Can you please  provide an example of what you would like to achieve (some sample data and expected output)? Also, provide a brief of what you have already done.
If you remove both numeric and alpha data from an alphanumeric field, you would be left with nothing
Maybe he wants to keep the special characters only.
Avatar of Rupesh Mishra
Rupesh Mishra

ASKER

Perfect. Wanted to show two fields - numeric and non-numeric in SSRS report.
Thank You
Welcome. Glad to help!