Generating random numbers within SELECT queries in SQL Server 2005

I was generating some test data and tried to use the RAND() function to query data. When trying this out on the Northwind database, it returned with the following result:

SELECT LastName, RAND() from Employees

The problem is that the randomly generated number is the same for all rows. What I need is a function that will generate the random number differently each time this is called.

After digging around, the easiest way I have found is to

1. Create a view that generates a random number
2. Create a function that calls the view

Here are the 2 statements I used:

CREATE VIEW RandomNumberView AS BEGIN     SELECT RAND() as RandNum
GO

CREATE FUNCTION GetRandomNumber() 
RETURNS FLOAT 
AS  BEGIN     RETURN SELECT RandNum FROM RandomNumberView
END

Then all you do is call your function (with schema name) to return a new random number:

SELECT LastName, dbo.GetRandomNumber() from Employees