Fabio, this is close!! I get a 0 for any # ending in 0

SET @myCol = 'ALL-10'

SELECT CONVERT(INT,SUBSTRING(LEFT(@myCol,PATINDEX('%[1-9][A-Z]%',@myCol+'A')),PATINDEX('%-[0-9]%',@myCol)+1,15)) myValue

0

But this is close thanks!

__Stephen

>Hi Stephen,
>
>try
>

>DECLARE @myCol varchar(15)
>
>SET @myCol = 'FAB-767LUN'
>
>SELECT CONVERT(INT,SUBSTRING(LEFT(@myCol,PATINDEX('%[1-9][A-Z]%',@myCol+'A')),PATINDEX('%-[0-9]%',@myCol)+1,15)) myValue
>

>
>Fabio