concatenate will work nicely until you get a table like:

AAA BBB 1
AA ABBB 2
A AABBB 3
AAABBB 4

And you want to return the 3.


Roni wrote:

Guys,

I prefer to use the index and match function, although concatenate is
also working =).
Thanks for the advise.

Roni

--

Dave Peterson