Base64_To_String

Converts Base64 data to a non-unicode varchar String

Syntax:

SELECT SQLHTTP.net.Base64_To_String ( @Base64 )

Arguments:

Name	Type	Description
@Base64	varchar(MAX)	Base64 data string

Return Type:

varchar(MAX)

Sample Usage:


DECLARE @Text varchar(MAX)
SET @Text = 'VGhlIHF1aWNrIGJyb3duIGZveCBqdW1wcyBvdmVyIHRoZSBsYXp5IGRvZw=='

SELECT SQLHTTP.net.Base64_To_String(@Text)

DECLARE @Text varchar(MAX)

SET @Text = 'VGhlIHF1aWNrIGJyb3duIGZveCBqdW1wcyBvdmVyIHRoZSBsYXp5IGRvZw=='

SELECT SQLHTTP.net.Base64_To_String(@Text)

-----------------------------------------------

The quick brown fox jumps over the lazy dog