How to extract alpha or numbers from a string within a SELECT statement WITHOUT a function call
I am using the following SQL to create a function to strip out characters or numbers. CREATE FUNCTION . ( @String NVARCHAR(MAX), @MatchExpression VARCHAR(255) ) RETURNS NVARCHAR(MAX) AS BEGIN SET…
