Got it!!!

1. create a view

CREATE VIEW vRandNumber

AS

SELECT RAND() as RandNumber

2. create a udf

CREATE FUNCTION RandNumber()

RETURNS float

AS

BEGIN

RETURN 7 + (SELECT RandNumber FROM vRandNumber) * 113.00

END

3. add it to view

SELECT name, date, replace(dbo.RandNumber(),'.','') 'cnt',.....

Got this from http://weblogs.sqlteam.com/jeffs/jeffs/archive/2004/11/22/2927.aspx