SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select *
into t
from (values ('Initiative: Credible Sources;'), ('Initiative: Just in Time;'), ('Initiative: Database Normalization;')) v(option_field_2)
3 rows affected

select replace(substring(option_field_2, 13, 999), ';', '') from t

(No column name)

Credible Sources

Just in Time

Database Normalization

select replace(stuff(option_field_2, 1, charindex(':', option_field_2) + 1, ''), ';', '')
from t

(No column name)

Credible Sources

Just in Time

Database Normalization