DECLARE @NameString VARCHAR(100)
SELECT @NameString='Abv'
SELECT @NameString=UPPER('Abv')
SELECT SUM(ASCII(SUBSTRING(@NameString,Number,1))-64) 'Sum_Of_Charater'
FROM MASTER.dbo.spt_values
WHERE Number BETWEEN 1 AND LEN(@NameString) AND type='P'
-- Check this Solution