I have a field that concatinates values as it goes through records.
The value it came up with for one example is:
SMITH, JOHN R.0SMITH, JOHN R.0SMITH, JOHN R.0JONES, ROBERT R.00
It is a string of names with a zero separating each name.
The number of characters in the field can change in any given example.
I want the loop to capture the first full name before the zero. In this case it would be:
SMITH, JOHN R.
The name of the field it is pulling from is:
PROV_NAME_DISPLAY
Any help would be much appreciated!
Thanks
Steve Boll

I only wanted the last instance of a name as it concatenated each name from each record in a group. The problem was that the last record in the group might not have a name in it.
But I used instr({@PROV_NAME_DISPLAY},"0") that gave me the length up to the first zero. Then just used Left and subtracted 1 for the zero.
Thanks
Steve