Hi Pete,
>Actually, based on this statement, isn't this to process all the matches for those expressions. In my scenario... there is either one record that matches or none. There should never be more than one match.
Yep. If there's really only one match, you can use LOCATE FOR instead of SCAN FOR.
Christof
--
Christof