Replace password with "******"

How can I replace password in SQL server table column with ******
In Access it can be done by Input mask: password
How can I do it in SQL server?
Thanks for help!
SimonThere is no such thing as an input mask in SQL Server.
What you could do is create a view that converts the password to ********,
and grant access for your users only to the view and not to the underlying
table.
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Simon Abolnar" <Simon.Abolnar@.tscng.net> wrote in message
news:uimePG#KFHA.1156@.TK2MSFTNGP09.phx.gbl...
> How can I replace password in SQL server table column with ******
> In Access it can be done by Input mask: password
> How can I do it in SQL server?
> Thanks for help!
> Simon
>|||Access is both a front end and backend tool (questionable about how good
it is, but that's a different discussion).
SQL Server won't visually present data any differently than it is stored
(outside of font choice).
If you want stars to appear, that is something you will have to program
around in your front end application, not the database system.
Simon Worth
Simon Abolnar wrote:
> How can I replace password in SQL server table column with ******
> In Access it can be done by Input mask: password
> How can I do it in SQL server?
> Thanks for help!
> Simon
>|||I threw together an article on this. No, not just for you; this is a common
enough question. :-)
http://www.aspfaq.com/2536
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Simon Abolnar" <Simon.Abolnar@.tscng.net> wrote in message
news:uimePG#KFHA.1156@.TK2MSFTNGP09.phx.gbl...
> How can I replace password in SQL server table column with ******
> In Access it can be done by Input mask: password
> How can I do it in SQL server?
> Thanks for help!
> Simon
>