calc md5 in sqlserver

SELECT CONVERT( VARCHAR(100) , HASHBYTES( 'MD5' , 'abc' ) , 2 );

HASHBYTES ( '< algorithm >', { @input | 'input' } )
< algorithm > = MD2 | MD4 | MD5 | SHA | SHA1 | SHA2_256 | SHA2_512