SQL syntax alphanumeric characters, SQL Server

Question

If I pull this ID down from my source system it looks like 9006ABCD.

What would the syntax look like if I just want to return 9006 as the ID?

Essentially, I don't need the alpha characters.

Possible duplicate of [SQL substring replacing](https://stackoverflow.com/questions/12390872/sql-substring-replacing) — Alessandro Da Rugna, Mar 18 '19 at 22:16

score 3 · Accepted Answer · answered Mar 18 '19 at 20:18

3

Assuming that '9006ABCD' is a string value, then you can extract the leading numbers using:

select left(id, patindex('%[^0-9]%', id + 'X') - 1)

Of course, there may be easier ways. If you just want the first four characters, then use left(id, 4).

answered Mar 18 '19 at 20:18

Gordon Linoff

1 Answers1