this statement would work but I was hoping to use a table so I don't have to hardcode this in the software.

replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(m1_dc.dbo.SalesOrderLines.omlPartLongDescriptionText,'Brighton','Belleair'),'Colony','Colonial'),'Cottage','Colonial II'),'Homestead','Shaker'),'Homestead II','Shaker II'),'Harmony','Hawthorne'),'Savannah','Springfield'),'Briarwood','Bronson'),'Jamestown','Jupiter'),'Shelby','Sanford'),'Lawrence','Longwood'),'Yorktown','Youngstown')