declare @randNum varchar(10)
set @randNum = (SELECT ABS(CHECKSUM(NEWID())%900000)+100000)
print @randNum
declare @randNum varchar(10)
set @randNum = (SELECT ABS(CHECKSUM(NEWID())%900000)+100000)
print @randNum