Posted by David Portas on 06/20/05 00:23

Formatting of results is best done client-side. However, if you want to
manipulate and store strings in the database then it maybe worthwhile
re-writing your functions in TSQL. Take a look at the range of string
functions in SQL Server Books Online.

..NET and the MS CryptoAPI should provide all the crypto functions you will
need. Although it can make sense to put encryption in the database, doing it
in the client or middle tier will serve most applications just as well or
even better.

--
David Portas
SQL Server MVP
--

[Back to original message]