InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 20:50:10 GMT20http://www.sqlservercentral.com/Forums/Topic1408115-391-1.aspxHi There,Yes I am very stupid.That's what you get for using someone else's libraries :)The RAT function called the RCHARINDEX inside it, and I missed the call when I was looking through the source.So, I decided to re-write the function, and as I was doing do, I found the reference, and before I could log on you asked the question!Thanks for you response.Sorry to waste your time.RegardsSun, 20 Jan 2013 14:16:44 GMTblock 5753http://www.sqlservercentral.com/Forums/Topic1408115-391-1.aspx[quote][b]block 5753 (1/16/2013)[/b][hr]As a bit of additional info, intellisense picks up the function correctly.But still getting:select dbo.RAT(' ',' hey there dudes',1)Msg 4121, Level 16, State 1, Line 1Cannot find either column "dbo" or the user-defined function or aggregate "dbo.RCHARINDEX", or the name is ambiguous.[/quote]you are not calling function "dbo.RCHARINDEX" from the dbo.RAT function ??can you post the text ?Wed, 16 Jan 2013 22:41:22 GMTdemonfoxhttp://www.sqlservercentral.com/Forums/Topic1408115-391-1.aspxAs a bit of additional info, intellisense picks up the function correctly.But still getting:select dbo.RAT(' ',' hey there dudes',1)Msg 4121, Level 16, State 1, Line 1Cannot find either column "dbo" or the user-defined function or aggregate "dbo.RCHARINDEX", or the name is ambiguous.Wed, 16 Jan 2013 19:36:52 GMTblock 5753http://www.sqlservercentral.com/Forums/Topic1408115-391-1.aspxHi All,I have a weird one for you that I was hoping to get some help with.I created and deleted a few functions.Then I created a new one (Called RAT)When I call it with SELECT dbo.rat(@param,@param) it comes back with a "Cannot find either column "dbo" or the user-defined function or aggregate "dbo.RCHARINDEX", or the name is ambiguous."Now, there used to be a function called RCHARINDEX, but its gone, and it doesnt come up in the list of functions.....I deleted it because for some reason I couldnt call it, but another function in the list worked fine, so its possibly a compounded problem,When I run select 1 from dbo.sysobjects where id = object_id('[dbo].[RAT]')select 1 from dbo.sysobjects where id = object_id('[dbo].[RCHARINDEX]')I get a hit on the first one, but not on the second one.I did drop the functions using the command:Use MastergoIF EXISTS (select 1 from dbo.sysobjects where id = object_id('[dbo].[RAT]') ) DROP FUNCTION [dbo].[RAT]Any suggestions? RegardsWed, 16 Jan 2013 18:20:54 GMTblock 5753