ALTER FUNCTION S_GetComputerName () RETURNS varchar (50) AS BEGIN declare @returnvalue varchar (50) select @returnvalue = hostname from master..sysprocesses where spid = @@ spid Return (Rtrim (@returnvalue)) END