@BINTOBASE64

Use the @BINTOBASE64 function to convert supplied binary data into BASE64 text.

Syntax

@BINTOBASE64 (data)
data

Can be one of the following:

  • The name of the source column that contains the data

  • An expression

  • A literal string that is enclosed within single quote marks

Example

@BINTOBASE64('12345') converts to 'MTIzNDU='