CREATE PROC AddToCodeNumber
	@code	VARCHAR(50),
	@number	INT
AS
BEGIN
	DECLARE @Length	INT,
			@i		INT

	SELECT	@Length = len(@code),
			@i = 0

	WHILE (SELECT SUBSTRING(@code,@length-@i,1)) IN ('1','2','3','4','5','6','7','8','9','0')
	BEGIN
		SELECT @i=@i+1
	END

	SELECT @number = RIGHT(@code,@i) + @number

	IF LEN(@number)=LEN(RIGHT(@code,@i))
	BEGIN
		SELECT LEFT(@code,@Length-@i) + CAST(@number AS VARCHAR(MAX))
	END
	ELSE
	BEGIN
		SELECT 'ERROR'
	END
END
RETURN
GO

EXEC AddToCodeNumber
	@code	='ABC/*-+32100',
	@number	=212

EXEC AddToCodeNumber
	@code	='ABC/*-+32100',
	@number	=2122346

IF OBJECT_ID ( 'tempdb..#Tally' ) IS NOT NULL
BEGIN
   DROP TABLE #Tally
END
GO


DECLARE @AlphaNumber varchar ( 20 )
DEcLARE @numtoadd    decimal ( 20, 4 )
DECLARE @NumPart     decimal ( 20, 4 )
DECLARE @Result      varchar ( 20 )
DECLARE @strlen      int
DECLARE @numpos      int

SET @AlphaNumber = 'ABC12345.6789'
SET @numtoadd    = 0.3211


SET @strlen = DATALENGTH ( @AlphaNumber )

SELECT TOP ( @strlen )
       IDENTITY ( int, 1, 1 ) AS N
INTO #Tally
FROM master.dbo.syscolumns

ALTER TABLE #Tally
ADD C char ( 1 )

UPDATE #Tally SET C = SUBSTRING ( @AlphaNumber, N, 1 )

--SELECT * FROM #Tally

SELECT @numpos = MIN ( N ) FROM #Tally WHERE C BETWEEN '0' AND '9' OR C = '.'

--PRINT @numpos

SET @NumPart = CAST ( SUBSTRING ( @AlphaNumber, @numpos, @strlen ) AS decimal ( 20, 4 ) )

--PRINT @NumPart

SET @NumPart = @NumPart + @numtoadd

SET @Result = LEFT ( @AlphaNumber, @numpos - 1 ) + LTRIM ( STR ( @NumPart, @strlen, 4 ) )

PRINT @AlphaNumber + ' + ' + LTRIM ( STR ( @numtoadd, 10, 4 ) ) + ' = ' + @Result

DROP TABLE #Tally