password in a Table

Hi,

I have a "password" field in a Table. How should I define it, that its
output is showed like "******"?

Thanks,
FaezehHi

You can encrypt the contents of the column using several different methods
see http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=30

If you are using .NET then the best thing to use is one off the algorithms
available through the framework.

The displaying of asterisks in a form is a feature of the form and not part
of SQL Server.

John

"F. Afroozi" <afroozi@.isac.rwth-aachen.de> wrote in message
news:327mtaF3jgn1lU1@.news.dfncis.de...
> Hi,
> I have a "password" field in a Table. How should I define it, that its
> output is showed like "******"?
> Thanks,
> Faezeh
>