SELECT ProductID, ProductName, Composition, REPLACE$($REPLACE$($Composition$,$ 'Man$-$Made', 'Synthetic'$),$ 'Man Made', 'Synthetic'$)$ AS NewComposition FROM YourTableName WHERE $($Composition LIKE $\text{'}\%$Man$-$Made$\%\text{'}$ OR Composition LIKE $\text{'}\%$Man Made$\%\text{'})$ AND ProductID BETWEEN $1050$ AND $1060$

Error ERROR $[42$S$02][$Microsoft$][$ODBC SQL Server Driver$][$SQL Server$]$Invalid object name 'YourTableName'.SELECT ProductID, ProductName, Composition, REPLACE$($REPLACE$($Composition$,$ 'Man$-$Made', 'Synthetic'$),$ 'Man Made', 'Synthetic'$)$ AS NewComposition FROM YourTableName WHERE $($Composition LIKE $\text{'}\%$Man$-$Made$\%\text{'}$ OR Composition LIKE $\text{'}\%$Man Made$\%\text{'})$ AND ProductID BETWEEN $1050$ AND $1060$

Error ERROR $[42$S$02][$Microsoft$][$ODBC SQL Server Driver$][$SQL Server$]$Invalid object name 'YourTableName'.