I have another question for the list.
I have a table that has two columns (col1=zip code and col2=Utility
company). One zip code=One utility company. And I have received help to
find those zip codes that have more than one utility company (duplicate zip
codes).
Now I would like to concatenate those so that if there are five rows
with the same zip, and different utility companies, I can make one row, with
one zip, and update one field to hold all five utility companies names.
But so far, MapInfo help on concatenation has been lacking.
TIA for all who reply.
cheers
rm
