change user password

hi, is it possible to change the current user's password from a
function/stored procedure , I mean, is there a system function/stored
procedure to do it? like the dbo.sp_password found in adaptive server
anywhere.

thanks in advance

Hugo