encrypte strings and numbers

i need a function for encrypte data in t-sql.any idea?
Regards,
OfirSQL does not have an inbuilt encryption function, except the one used for
passwords... If you search for Encrypt SQL Data on the web you will get many
results... Some indiviuduals have come up with simple encryption Sps, etc...
Here is a URL for a 3rd party product..
http://www.activecrypt.com/
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"ofir" <ofir@.millenium.org.il> wrote in message
news:uTAz%231QZFHA.3628@.TK2MSFTNGP09.phx.gbl...
>i need a function for encrypte data in t-sql.any idea?
> Regards,
> Ofir
>