Convert varbinary column to base64
SELECT
Id,
FileInBinary, --the varbinary value we want converted to base64
CAST('' AS XML).value('xs:base64Binary(sql:column("FileInBinary"))', 'varchar(max)') AS FileInBase64
FROM Files
SELECT
Id,
FileInBinary, --the varbinary value we want converted to base64
CAST('' AS XML).value('xs:base64Binary(sql:column("FileInBinary"))', 'varchar(max)') AS FileInBase64
FROM Files