SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (
  id int identity primary key,
  x varbinary(10)
);
insert t (x) values 
  (0x0001020304),
  (0x0506070809)
;
select * from t;


id
x


1
0x0001020304

2
0x0506070809


select 
  *
from t
cross apply (
  select x AS '*' for xml path('')  
) as ca (b64);


id
x
b64


1
0x0001020304
AAECAwQ=

2
0x0506070809
BQYHCAk=


select 
  convert(varchar(max),x,1) as hex 
from t


hex


0x0001020304

0x0506070809


select 
  string_agg(b64,'|'),
  string_agg(convert(varchar(max),x,1),'|')
from t
cross apply (
  select x AS '*' for xml path('')  
) as ca (b64);


(No column name)
(No column name)


AAECAwQ=|BQYHCAk=
0x0001020304|0x0506070809