SQL SERVER – Find First Non-Numeric Character from String

there is no function available to  Find the first non-numeric character from the string .

But this can be found using PATINDEX. The function PATINDEX exists for quite a long time in SQL Server

-- How to find first non numberic character

USE tempdb

GO

CREATE TABLE MyTable (ID INT, Col1 VARCHAR(100))

GO

INSERT INTO MyTable (ID, Col1)

SELECT 1, '1one'

UNION ALL

SELECT 2, '11eleven'

UNION ALL

SELECT 3, '2two'

UNION ALL

SELECT 4, '22twentytwo'

UNION ALL

SELECT 5, '111oneeleven'

GO

-- Use of PATINDEX

SELECT PATINDEX('%[^0-9]%',Col1) 'Position of NonNumeric Character',

SUBSTRING(Col1,PATINDEX('%[^0-9]%',Col1),1) 'NonNumeric Character',

Col1 'Original Character'

FROM MyTable

GO

DROP TABLE MyTable

GO

Here is the resultset: