-- BASE64.SQL sample script demonstrating xp_base64encode and xp_base64decode
--
-- Michael Coles, MCDBA
-- 7/2005
--
DECLARE @plain VARCHAR(255)
SET @plain = 'THIS IS A TEST, THIS IS ONLY A TEST'

EXEC master..xp_base64encode @plain

DECLARE @base64 VARCHAR(255)
SET @base64 = 'VEhJUyBJUyBBIFRFU1QsIFRISVMgSVMgT05MWSBBIFRFU1Q='

EXEC master..xp_base64decode @base64