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
