Help: @@SERVERNAME returns gibberish

SQLDenis · Apr 1, 2006

When I run select @@SERVERNAME
I get back this: 0x417072696C466F6F6C73

What does this mean?

Denis The SQL Menace
SQL blog:

Personal Blog:

chrissie1 · Apr 1, 2006

mmm, let me think.

April fool, right?

Christiaan Baes
Belgium

"My new site" - Me

bborissov · Apr 1, 2006

To get the right Server Name

Code:

declare @str1 varbinary(80)
SET @str1 = 0x417072696C466F6F6C73
PRINT convert(varchar(80), @str1)

;-)
(I like that one)

Borislav Borissov