As long as the initial_caps_proc doesn't have a suspend statement, it will basically be seen as a function call. To use it to update records one time:
Update MyTable set Column_A = (select OutVar from initial_caps_proc(Column_A)), Column_B = (select OutVar from initial_caps_proc(Column_B)); I haven't tested this but it should work if memory serves me correctly. :) Woody (TMW) -------------------------------------------------- From: "Raith,Daniel" <[email protected]> Sent: Thursday, October 10, 2013 12:47 PM To: <[email protected]> Subject: RE: [firebird-support] for select stored procedure question > It's an internal procedure. I fixed my message file version issue and the > error simply says: > > SQL error code = -804 > Function unknown > initial_caps_proc > > However this works: > > select * from initial_caps_proc( 'testing my test' ) >
