Monday, August 27, 2018

How To Split/Separate Numbers And Alphabets From Alpha Numeric String In SQL Server

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