/****** Object:  Stored Procedure dbo.ujo_bump_digit    Script Date: 12/1/2005 11:49:13 PM ******/


create proc ujo_bump_digit @i_odigit VARCHAR(13), @result VARCHAR(1) output, @did_roll int output
as
    declare @new_val int,
            @orig_val int           
    
    
    set @did_roll = 0
    set @orig_val = ASCII(@i_odigit)    
    IF @orig_val = 57
    begin
            /* go from '9' to 'a'*/
            set @new_val = 97
    end
    else IF @orig_val = 122  
    begin
            /* go from 'z' to '0'*/
            set @new_val = 48
            set @did_roll = 1            
    end
    else
    begin            
            set @new_val = @orig_val + 1
    end

   set @result = CHAR(@new_val)
GO