PRINT '----------- #FUNC NAME# ----------'
GO

IF EXISTS
(
SELECT  [name]
FROM    [sysobjects]
WHERE   [id] = object_id(N'#FUNC NAME#')
AND     [type] = 'FN'
)
BEGIN
PRINT   '  DROPPING EXISTING FUNCTION'
DROP FUNCTION [dbo].[#FUNC NAME#]
END
GO

PRINT   '  CREATING FUNCTION'
CREATE FUNCTION [dbo].[#FUNC NAME#]
-- ADD PARAMETERS HERE
RETURNS /* datatype */
AS
BEGIN
/****** Object:  FUNCTION #FUNC NAME# ********************************/
-- Script Date: #DATE#
-- Dev Org:
-- Author:
--
-- Description:
--
-- Change History:
/****************************************************************/
-- DECLARATIONS

-- OBJECT CREATION

-- BODY

-- RETVALS
RETURN <parameter/value>
END
GO

IF EXISTS
(
SELECT  [name]
FROM    [sysobjects]
WHERE   [id] = object_id(N'#FUNC NAME#')
AND     [type] = 'FN'
)
BEGIN
PRINT   '  CREATED FUNCTION #FUNC NAME#'
END
ELSE
BEGIN
PRINT   '  * FAILED CREATING FUNCTION #FUNC NAME#'
END
GO