Simple function with passed parameter

[IanHunter]

In framework manager, can I create a simple function which takes a passed paramter.  The function is to basically take a string and extract certain elements of it and return them rearranged.  The passed parameter will be a string which will come from various fields from various tables.

[MFGF]

Hi,

The idea generally is to create your function in your database, then import its definition into Framework Manager.  It should then appear as a function that can be called both from within FM and from within Report Studio (if you include it in your published packages).

Regards,

MF.

[IanHunter]

I thought as much.  The reason I wanted to do it this way was that we are accessing our data over a odbc link and I would have to create a stored procedure to do it.  It just seemed a bit of overkill just to rearrange a string.