if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[f_int2hex]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[f_int2hex]
GO

/*--數字轉換成16進制

--鄒建 2004.04(引用請保留此信息)--*/

/*--調用示例

	--調用
	select dbo.f_int2hex(123)
--*/
create function f_int2hex(@num int)
returns varchar(100)
as
begin
	declare @re varchar(100)
	set @re=''
	while @num>0
		select @re=substring('0123456789ABCDEF',@num%16+1,1)+@re
			,@num=@num/16
	return(@re)
end
go