How to remove certain part of a column after parenthesis in BI report

Summary:

Hi All,

I want to remove the part of Tax Reporting Unit column from where the parenthesis is starting. Please suggest the function to use this in sql.

Example: ABC Corporate Services, LLC(20-1111111)

This is the Tax reporting unit. Client dont want to see the part (20-1111111).

Regards

Dona Das