>>Perhaps this will do, then:
>>
>>m.lcInput = "Mytable.FieldXyx = '233' and (MyTable.Field233 > 344) and !empty(mytable.myfield) and someothertable.field3 = '333'"
>>m.lcHold = STREXTRACT(m.lcInput,"!empty(",")",1,5)
>>m.lcOutput = STRTRAN(m.lcInput, m.lcHold, "LEN" + STREXTRACT(m.lcHold,"(",")",1,4) + ">0")
>>
>
>Perfect. Thank you very much.
You're welcome.
Just remember that if "!empty()" may occur more than once, then you'll have to consider insert a DO WHILE loop until the function is completely replaced in the expression.
----------------------------------
António Tavares Lopes