Base64

Hi,
is there a way to extract data in base64 ...
i'd like to do something like : select cast(A_PHOTO as binary base 64) from
article
does anyone know a way to do it.
Best regards.Franck Fouache wrote:
> Hi,
> is there a way to extract data in base64 ...
> i'd like to do something like : select cast(A_PHOTO as binary base 64) fro
m
> article
> does anyone know a way to do it.
What's the version of SQL Server?
In SQL Server 2005 I would implement a simple scalar CLR function
returning base64 encoded string. The function could be used in that way:
SELECT dbo.base64_encode(A_PHOTO) from article
In SQL Server 2000 CLR integration is not available.
In that case please refer to:
http://www.sqlservercentral.com/col...eencryption.asp
Best regards,
Marcin Guzowski
http://guzowski.info|||"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:em986e$mkl$1@.atlantis.news.tpi.pl...
> In SQL Server 2000 CLR integration is not available.
> In that case please refer to:
> http://www.sqlservercentral.com/col...eencryption.asp
>
There's an updated version at
http://www.sqlservercentral.com/col...oolkitpart4.asp
as well.sql