Using SQL 2008 R2

The second method gave me the result of <localhost>

The first method created the function correctly, but didn't display a result.

I tried this, but something is wrong?

DECLARE @IPADDY nvarchar(255)

EXECUTE [dbo].[GetCurrentIP], @IP_Address=@IPADDY OUTPUT

PRINT @IPADDY

Thanks!