Set the result mode to text and run this query
set nocount on select space(7-len(replicate(char(42),no)))+ replicate(char(42),no*2-1) from ( select top 5 row_number() over (order by name) as no from sysobjects ) as t union all select space(5)+replicate(char(124),3) union all select cast(0x4861707079204E65772059656172 as varchar(100))
Tags: t-sql, sql_server, Happy-New-Year,