Generar un número al azar

SELECT ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS [RandomNumber],Contrato,Grupo,Integrante
From Contratos where contrato > 400000