frop

DECLARE     @ServobjectGrpcode T_Code_Group03
    ,@SOG1 CHAR
    ,@SOG2 CHAR
    ,@SOG3 CHAR
    ,@DeliveryWarranty INT
    ,@InstalWarranty INT

SELECT  @ServobjectGrpcode='X-R'

SELECT  @SOG1=SUBSTRING(@ServobjectGrpcode,1,1)
    ,@SOG2=SUBSTRING(@ServobjectGrpcode,2,1)
    ,@SOG3=SUBSTRING(@ServobjectGrpcode,3,1)

SELECT  @AfterDelivWarr=ascii(@SOG1)-64 +
        CASE
            WHEN @SOG2='-' THEN 0
            ELSE ascii(@SOG2)-64
        END
    ,@AfterInstallWarr=ascii(@SOG3)-64

SELECT  @AfterDelivWarr
    ,@AfterInstallWarr