rand function problem

[joxa83]

I need to call rand functino within another function but server raises an error.For example I can't create followng function

create function dbo.test()
returns float
as
begin
declare @i float
select @i = rand()
return @i
end

 

[JarlH]

Seems like a SQL Server problem. You'll probably get (better) answers in the SQL Server forum.