Ok I looked at it a third time and found the '%[1-9], and changed it to a 0-9 and it's working.

Thanks again!

>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