CODEWITHSUNDEEP
sqlsql-serversql-server-2008sql-server-2008-r2
sai bharath
sai bharath

Reputation: 844

is not a recognized built-in function name

Created a function 

CREATE FUNCTION Split_On_Upper_Case(@Temp VARCHAR(1000))
RETURNS VARCHAR(1000)
AS
BEGIN
DECLARE @KeepValues AS VARCHAR(50)
SET @KeepValues='%[^ ][A-Z]%'
WHILE PATINDEX(@KeepValues COLLATE Latin1_General_Bin,@Temp)>0
SET @Temp=STUFF(@Temp,PATINDEX(@KeepValues COLLATE Latin1_General_Bin,@Temp)+1,0,' ')
RETURN @Temp
END

When iam trying to exexute this SELECT Split_On_Upper_Case('SaiBharath') It gives an error "'Split_On_Upper_Case' is not a recognized built-in function name.".Can someone please explain this

Upvotes: 53

Views: 186633

Answers (3)

Mansoor
Mansoor

Reputation: 4192

Add [dbo] in prefix and then execute as same :

SELECT [dbo].[Split_On_Upper_Case] ('SaiBharath')

Upvotes: 84

Ravi Matani
Ravi Matani

Reputation: 822

To execute function in sql, prefix dbo should be used.

SELECT [dbo].[Split_On_Upper_Case] ('SaiBharath')

Upvotes: 13

Radu Gheorghiu
Radu Gheorghiu

Reputation: 20509

Just to make sure, set the database you created your function on first by using the use clause and then prefix the call of your function with dbo.

USE <DatabaseName>

SELECT dbo.Split_On_Upper_Case('camelCase')

Also, a good practice is prefixing each function or database object for that matter, with its schema name.

Upvotes: 9

Related Questions