is not a recognized built-in function name

Question

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

@Mansoor - Please?

Rich Benner
– Rich Benner

2016-12-19 09:30:01 +00:00
Commented Dec 19, 2016 at 9:30 — Rich Benner
– Rich Benner, Commented Dec 19, 2016 at 9:30

Mansoor · Accepted Answer · 2017-05-26 04:57:34Z

84

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

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

edited May 26, 2017 at 4:57

answered Dec 19, 2016 at 9:01

Mansoor

4,1921 gold badge19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

GuidoG Over a year ago

Good answers have not only code but also some explanation.

Daniel Bradley Over a year ago

To be fair, Microsoft seem to provide very little explanation of this either. This answer has been enough to solve the frustration I've had for the past half hour trying to execute functions.

Neil Over a year ago

Thanks for the answer to this but I wonder if there is a way of avoiding using dbo. ? Please see my question here :stackoverflow.com/questions/52953159/…

MindRoasterMir Over a year ago

Even this is not solving the problem. I am getting "Function not found" error, even i have reconnected the server and restarted to refresh the memory. thanks

Ravi Matani · Accepted Answer · 2016-12-19 09:04:44Z

13

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

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

answered Dec 19, 2016 at 9:04

Ravi Matani

8221 gold badge8 silver badges21 bronze badges

Comments

Community · Accepted Answer · 2020-07-29 18:27:52Z

9

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.

edited Jul 29, 2020 at 18:27

CommunityBot

11 silver badge

answered Dec 19, 2016 at 9:01

Radu Gheorghiu

20.6k16 gold badges78 silver badges113 bronze badges

Collectives™ on Stack Overflow

is not a recognized built-in function name

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related