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]
CREATE FUNCTION dbo.SplitOnSpace (
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.
ACN is the world's largest direct seller of telecommunications and essential services.
ACN Digital Phone Service customers automatically enjoy unlimited calling to 60 landline
destinations around the world, including India, Mexico and the UK!