You are totally right...

typin' mistake...

the 'CAST' is to a NVARCHAR(MAX)

I tried a lot whitout that CAST and it returned another 'md5' string... i figure that the problem is in the...

MD5 is a 'one way' algorithm. you can't decrypt it.

is very usefull to encrypt passwords, or data that you don't need to read directly.

for instance, if i store a md5...

thanks for your answer jim.powers... but i'm still not clear in this case.

I don't know if i have to ask in other topic (because i guess that is not...

I have a big question (I guess that is big only for me), but... 'what is the real advantage of INNER JOIN??? why not to use WHERE condition to join...