UDF Invalid object name

[mbowles]

I have a udf called Split. It was create like so:
CREATE FUNCTION dbo.Split

It returns a table of values from a comma separated nvarchar sent to it. No matter how I call it, I get Invalid object name 'dbo.Split'

Any thoughts?

 

[SQLSister]

You don't need the dbo when you have table result. Try it without the dbo prefix.

Questions about posting. See faq183-874

 

[mbowles]

tried that as well. Trying somehting like this:
select * from myTable where id in (Split(1,51,100',','))

I cant even exec it from query analyzer, same error.

 

[mbowles]

it seems that I was not calling it like so:
select * from Split('1,54',',')

to get the results of the table..thanks!