Daniel,

> I guess I was actually on FB2.5. After switching back to FB1.5, I think I'm out
> of luck because the SUBSTRING internal function requires integer literals. So
> this statement isn't possible:

Have a look at the UDF libraries listed on the IBPhoenix web site, I am pretty sure that you will find one which has an appropriate function (it will likely also run considerably faster than the SP logic)


Sean