get integer vale

Question

hi

I have this value

AS Printer 18558059431 R

I need 18558059431 this 11 digit number please help.

kindly help.

Answer 1

thnaks

I have used

http://blog.sqlauthority.com/2008/10/14/sql-server-get-numeric-value-from-alpha-numeric-string-udf-for-get-numeric-numbers-only/.

Answer 2

declare @s nvarchar(200) = 'AS Printer 18558059431 R'
;WITH prepart AS (
   SELECT substring(@s, patindex('%[0-9]%', @s), len(@s)) AS s
), postpart AS (
   SELECT substring(s, 1, patindex('%[^0-9]%', s) - 1) AS s
   FROM   prepart
)
SELECT convert(bigint, s)
FROM   postpart

---

Erland Sommarskog, SQL Server MVP, [e-mail]