if exists (select name from dbo.sysobjects where name='ToStringDate') drop function ToStringDate go create function ToStringDate(@Tarikh int=0) RETURNS nvarchar(12) begin declare @res as nvarchar(12); if (@tarikh = 0) return '0000/00/00'; set @res = substring(cast(@Tarikh as nvarchar), 0 , 5) + '/' + substring(cast(@Tarikh as nvarchar), 5 , 2) + '/' + substring(cast(@Tarikh as nvarchar), 7 , 2) return @res; end GO --select dbo.ToStringDate (0)