Quick Help - Please help in the expression

[gshilpa24]

Hi,

I have a column called full_name
and the values are ,

CEI-Overall Statisfaction-T2B(DB)
CEI-Overall Statisfaction-T2B(DB/TEM)
CEI-Overall Statisfaction-T2B(HW)
CEI-Associate Service-T2B(DB)
CEI-Associate Service-T2B(DB/TEM)
CEI-Associate Service-T2B(HW)
Green Clients %(DB)
Green Clients %(DC/TEM)
Green Clients %(HW)

etc...

i have to extract only wat is there within the braces.

DB
DC/TEM
HW

please let me know how to extract only those with the help of substring.


data base is SQL Server 2008.

i also have another column against it without the DB, DC/TEM, HW

[blom0344]

Combine substring with position/posstr/pos  (can't recall how Cognos names this function) to check the position of  '(' and ')'

[gshilpa24]

Thank You for the response. I will try these functions.