Try with a stored procedure. I had used stored procedure of MSSQL with PB12.5 years back and it used to work so maybe you can move your logic from DB function to DB stored procedure and give it a try. 

What database interface?

you cannot call it from PowerScript (a la "Select * from dbo.MyTableFunction(42,'bananas') using SQLCA;") because it returns a table, not a single, bind-able value, but you can include it in a Select statement where the table returned by the SQL function is joined to other table(s) in order to produce a single value.

With the SNC database interface, you can use a table function as the From clause in a Select statement that is the data source for a DataWindow or DataStore, such as "Select * from dbo.RangeOfNumbers(:first_value,:last_value)", where "first_value" and "last_value" have been defined as retrieval arguments.

I know this works with the SNC interface. I've never used ODBC, however.

MSSQL Server

PB 17

Hi, Robert -

What database (vendor, version, etc.)?

What version/release/build of PB?