When I ran the SELECT statement by itself I see that this is a function that exists, what is the change you are making to the default Function?

I changed the function name and tried to create it and I receive an error.

IF exists (SELECT * from dbo.sysobjects

WHERE id = object_id(N'[dbo].[SplitOnSpace]')

AND OBJECTPROPERTY(id, N'IsTableFunction') = 1)

DROP FUNCTION [dbo].[SplitOnSpace]

GO

CREATE FUNCTION dbo.SplitOnSpace (

@vcDelimitedString varchar(8000),

@vcDelimitervarchar(1)

)

GO

Msg 102, Level 15, State 1, Procedure SplitOnSpace, Line 4

Incorrect syntax near ')'.

The only change I made to your expamle was the object name.