Viewing post 1 (of 1 total)
Here is a recursive solution:
ALTER FUNCTION ALPHA_NUM(@NUM BIGINT)
RETURNS VARCHAR(10) ASBEGIN
DECLARE @MOD AS BIGINT
DECLARE @REM AS BIGINT
DECLARE @ALPHA AS VARCHAR(10)
SET @MOD = (@NUM-1) % 26
SET @REM...
April 29, 2010 at 4:15 am
#1159522