Perry ---
How about something like:
x="group(brakes)"
y=LEFT(STRTRAN(x,"group("),LEN(STRTRAN(x,"group("))-1)
>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05