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