you can use this and manipulate this query to code as needed..

DECLARE @GENRANDOM nvarchar(9)

SET @GENRANDOM =LEFT(SUBSTRING (RTRIM(RAND()) + SUBSTRING(RTRIM(RAND()),3,11), 3,11),9)

--SELECT SUBSTRING(@GENRANDOM ,3,1)

SELECT @GENRANDOM as 'RANDOM_NUMBER'