Right Trim function

[Tamrak]

Good afternoon,

I have raw data that need to trim the right side of information. The data looks like this:

Field name = Name

Peters, John (F90780/GA)
Roberts, Frank (FG3434H/FA)
Perkins, May (Ffd435/AA)

....

What query should I write to eliminate the right side of information? All I need is to have the information in parenthesis going away. So, the results will be:

Peters, John
Roberts, Frank
Perkins, May

Thank you for your time.

(Tried to use right trim and it does not work. The information in the parenthesis has 9 characters in length + two for the open and close parenthesis. The field type is a text field.)

 

[PHV]

Left(Name, Len(Name)-12)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Tamrak]

Thank you for your information.