/****** Object:  User Defined Function dbo.uuid_from_char    Script Date: 12/1/2005 11:50:34 PM ******/



/* Star 14448560 ADD FUNCTION UUID_FROM_CHAR */
CREATE FUNCTION [dbo].[uuid_from_char]( @uuid varchar(36) )
returns uniqueidentifier
as
begin
    return convert(uniqueidentifier,@uuid)
end
GO
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [ca_itrm_group]
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [ca_itrm_group_ams]
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [public]
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [upmadmin_group]
GRANT EXECUTE ON  [dbo].[uuid_from_char] TO [upmuser_group]
GO