Convert alphanumeric to numeric
November 16, 2011 Leave a comment
Below script is to convert alpha numeric mobile numbers to numeric
here I have given mobile number as ‘1-800-MSFT’
Result is:
Filed under Scripts
About Sunilreddy
Hi All, This is SunilReddy working as Senior Developer. Am here to share my knowledge and experience with you. Hope your wishes will be with me as your valuable comments on my posts...
Recent Posts
- Trigger SSIS package when files available in a Folder part#2
- Trigger SSIS package when files available in a Folder
- Execute SSRS report from SSIS package
- Using OUTPUT Clause in DML statements.
- Number of character occurrences in String
- Convert alphanumeric to numeric
- Generate insert statements of records in a table
- Rename DB Constraint
- Know about costliest query running right now
- Scripts to find details about ‘logins’ & ‘Roles’
Categories
- Articles (2)
- Distinct Categories (7)
- Errors in SSIS (1)
- Jobs (1)
- MS BI Related (20)
- Scripts (10)
SocialVibe