For the record, PWDENCRYPT is also not secure:

http://www.theregister.co.uk/2002/07/08/cracking_ms_sql_server_passwords/

Crap. I had an eloquent reply to this, but Firefox/sqlservercentral swallowed it.

Ok - I'm too lazy to type it all again, have a look at the sql and come...

JunkMailVictim: As nicerguy crudely points out, the ENCRYPT function does NOT encrypt anything, it merely hex ENCODES the string, which is quite useless from a security standpoint. If you...

Yikes. So much for that idea, then.

Uhm - executing this in SQL 2000

select ENCRYPT('abc123')

yields

0x610062006300310032003300

So I'd have to say you're wrong.