SQL Inline Function

Question

I have a User Defined Function on database named MyFunc. It takes a string parameter and returns a scalar value.

And MYTABLE has two columns: ID, NAME

So Why is the following query error?

SELECT ID, MyFunc(NAME)
FROM MYTABLE

amit_g · Accepted Answer · 2011-06-13 16:00:35Z

4

Qualify it with schema

SELECT ID, dbo.MyFunc(NAME)
FROM MYTABLE

post the function if it doesn't work.

answered Jun 13, 2011 at 16:00

amit_g

31.3k8 gold badges67 silver badges124 bronze badges

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

1 Answer 1