Would this work for you?
DECLARE @pn varchar(15)
SET @pn = 'FLR-142A'
SELECT
CAST(
CASE WHEN RIGHT(SUBSTRING(@pn, CHARINDEX('-', @pn)+1,15),1) <= '9'
THEN SUBSTRING(@pn, CHARINDEX('-', @pn)+1,15) ELSE
LEFT(SUBSTRING(@pn, CHARINDEX('-', @pn)+1,15),
LEN(SUBSTRING(@pn, CHARINDEX('-', @pn)+1,15))-1) END
AS int)
>Thanks Serg.
>
>select Cast(right(rtrim(pa_page),3) AS int) AS 'value',
>* from deppage
>
>errors on :
>Syntax error converting the varchar value 'O-8' to a column of data type int.
>
>I have lots of Embedded #'s in this column. XXX-NNNX or XX-NN or XXX-NNX
>
>Maybe a union to pull from the 3 NNN #'s as well as the primary 2 NN #'s?
>
>I'm still getting Whacked by the occassional last Letter?
>
>
>__Stephen
>
--sb--