I'm not trying to replace any words, I'm simply trying to remove specific words from the table without eliminating the entire string.
I tried this:
replace ([CRIDGI], 'inactive','') AS [CRID],
You can do this using nested replaces:
select replace(replace([CRIDGI], 'inactive', ''), 'active', '') AS [CRID]
Alas, SQL in general -- and most databases -- have pretty lousy string manipulation capabilities. It is hard to do better than the nested replace, although your database might have some functionality that would help (such as Oracle and Postgres).