Convert a base64 to varbinary
SELECT Id, FileInBase64, --the base64 value we want converted to varbinary CAST(FileInBase64 AS xml).value('xs:base64Binary(.)', 'varbinary(max)') AS FileInBinary FROM Files
SELECT Id, FileInBase64, --the base64 value we want converted to varbinary CAST(FileInBase64 AS xml).value('xs:base64Binary(.)', 'varbinary(max)') AS FileInBinary FROM Files