I am referencing this article:

http://www.kenticosolutions.com/Developer-Tips/Tip/May-2011/Many-to-Many-relationships-in-the-Kentico-CMS-Cont.aspx

Essentially my goal is to create a filter that allows me to select news documents based on content editor selection of multiple custom document type attributes. Business Units, Regions, etc., which are being stored in the custom doc type table as pipe delimited lists.

Referencing the above article he creates a SQL function to split this column data allowing content to be filtered. What I am not understanding is WHERE I am supposed to create this function. When I create a custom query under the given document type, it does not seem to be available to the other queries under that same type. When I try and create it under system tables as a stored proc, the syntax does not appear to be correct and, as I am not a DBA, I am not sure how to resolve the issues created.

To me, it seems as if I am simply not putting this function in the correct place and/or I am not referencing it properly.

Any help with this would be greatly appreciated.