UDF question urgent

[brad12345]

I have a column of UmpireID from Umpire table and would like to randomly select a new umpire that isnt the @UmpireID the user puts in as return value anyone help my atempt below

 

create function dbo.getSecondUmpire 
(@UmpireID)
returns int
as
begin
return (select rand(UmpireID) from Umpire having rand(UmpireID) != @UmpireID)
end

[fenway]

Don't double-post!