The problem you have of course is that the formula_text is a LONG column, which does not support any functions applied to it such as LIKE...
One suggestion might be to extract the text from all the formulas into, say, a spreadsheet, then do a string search within the spreadsheet.
Alternatively, you could possibly create your own table like FF_FORMULAS_F except the formula_text column should be CLOB. CLOB columns can have things such as LIKE applied to them in WHERE CLAUSES - then just copy the data from FF_FORMULAS_F into your version, and do the query there.
Alternatively, I seem to remember having in my possession a function that converts LONG to VARCHAR, I need to try and resurrect it from wherever I have hidden it.
_________________________
L&K
CT
Previous Topic
Index