Encryption on 1 field

Is there a way to encrypt just one field in a table? If not I guess I could
use MD5. Can anybody make a suggestion on the best way to do this?Hi
As I undestood you would like to store the passwords, am I right?
As far as I know you cannot encrypt only one field and regarding to storing
the passwords do search on internet ,there are posts (examples) by Steve
Kass how to encrypt and store them.
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:F26C9AE8-B6A9-4EDD-8129-1A2136C8F8F8@.microsoft.com...
> Is there a way to encrypt just one field in a table? If not I guess I
could
> use MD5. Can anybody make a suggestion on the best way to do this?|||> Is there a way to encrypt just one field in a table? If not I guess I
could
> use MD5. Can anybody make a suggestion on the best way to do this?
You can do it from clint app, or you can use 3rd party tools - check
http://www.activecrypt.com/products.html, for example.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thanks for the input, I didn't think you could but it never hurts to ask.
What I want to do is encrypt credit card numbers.
"DAVID S" wrote:

> Is there a way to encrypt just one field in a table? If not I guess I coul
d
> use MD5. Can anybody make a suggestion on the best way to do this?|||Thank you so much, I will check on this software.
"Dejan Sarka" wrote:

> could
> You can do it from clint app, or you can use 3rd party tools - check
> http://www.activecrypt.com/products.html, for example.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>|||Try the sofware xp_crypto 2.5
search for xp_crypto 2.5 on google
it worked in my case
though besides it i also have udf_encrypt udf_decrypt for my database
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:F26C9AE8-B6A9-4EDD-8129-1A2136C8F8F8@.microsoft.com...
> Is there a way to encrypt just one field in a table? If not I guess I
could
> use MD5. Can anybody make a suggestion on the best way to do this?