>I have to go through a table and choose part desriptions to put in a report; here's the problem --- the way the parts are listed in the table is like this:
>
>group(brakes)
>group(gears)
>etc.
>
>I need to remove the string within the parentheses to place in a report. HELP!!
>
>Perry
You have AT() and SUBSTR() functions to make string manipulations, e.g. if you want to retrieve part of string between parentheses, then you use AT to find position of the left and right parenthesys and then use SUBSTR() to get result.
Edward Pikman
Independent Consultant