sql server select as base64 column

Question

Is there any simple function for get this output.

SELECT Title FROM Table WHERE Id = 1 
---- My title

Desire function or etc ...

SELECT MYBASE64ENCODE(Title) FROM Table WHERE Id = 1 
---- TXkgdGl0bGU=

I need the function for ecnode string to base64.

If answer is this so how can put my column as input of my query.

Possible duplicate of [Base64 encoding in SQL Server 2005 T-SQL](http://stackoverflow.com/questions/5082345/base64-encoding-in-sql-server-2005-t-sql) — James Z, May 21 '16 at 14:09
@JamesZ i dot thinks so it's an complex query i need the function not select inside select. — Mohammad Hossein Fattahizadeh, May 21 '16 at 14:12

score 3 · Accepted Answer · answered May 21 '16 at 14:14

Maybe create a User-defined function something like this.....

CREATE FUNCTION dbo.get_base64Coded (@Input nvarchar(4000))
RETURNS  nvarchar(4000)
AS
BEGIN
  Declare @Output nvarchar(4000);

SELECT
   @Output = CAST(N'' AS XML).value(
          'xs:base64Binary(xs:hexBinary(sql:column("value")))'
        , 'VARCHAR(MAX)')   
FROM (
       SELECT CAST(@Input AS VARBINARY(MAX)) AS value
     ) AS A;
  RETURN @Output      
END

Your query would look something like...

SELECT dbo.get_base64Coded(Title) FROM Table WHERE Id = 1

Alternative function body, `DECLARE @InputBinary varbinary(MAX) = CAST(@Input AS varbinary(MAX)); RETURN CAST(N'' AS XML).value( 'xs:base64Binary(xs:hexBinary(sql:variable("@InputBinary")))' , 'VARCHAR(4000)');` — Dan Guzman, May 21 '16 at 14:40

sql server select as base64 column

1 Answers1