IsBase64

Checks whether a string is Base64 encoded.

Syntax:

SELECT SQLHTTP.net.IsBase64 ( @Text )

Arguments:

Name	Type	Description
@Text	nvarchar(MAX)	String to be checked.

Return Type:

bit

Return Values:

0 = Text is NOT Base64 encoded
1 = Text IS Base64 encoded

Sample Usage:


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

SELECT SQLHTTP.net.IsBase64(@Text)

DECLARE @Text nvarchar(MAX)

SET @Text = 'VGhlIHF1aWNrIGJyb3duIGZveCBqdW1wcyBvdmVyIHRoZSBsYXp5IGRvZw=='

SELECT SQLHTTP.net.IsBase64(@Text)

-----