Hi All,

I have a string column as below
'Gender: Male; Age: 25-44; Household Income: $80,000 - $100,000 p.a.; Household Type: Couple Only'
i want to extract the string part " Household Income: $80,000 - $100,000 p.a.; " , i cannot use a specific length because the string differs i need to extract it based on the word Household Income and the semi colon.

can any one provide me the sql. below is what i am trying
select substring('Gender: Male; Age: 25-44; Household Income: $80,000 - $100,000 p.a.; Household Type: Couple Only' from 'Household Income' for ';');