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 |