Today I am going to Explain how you can split/separate numbers and alphabets from an alphanumeric string in SQL server. When you work with any database related application either that is in web or windows application sometime based on your requirement you have alphanumeric string and you just want only numbers from that string and want to use that numbers in your entire application as per your need like either use like as a variable, parameter or also use like as a string concatenation.
source https://www.c-sharpcorner.com/Blogs/how-to-splitseparate-numbers-and-alphabets-from-alpha-numeric-string-in-sql-server
No comments:
Post a Comment