If '_x0020_' and '_x002f_' are going to be the only patterns that need to be replaced, then this following code with do the trick for you!

First, check out how i set up the environment by providing the Tables and the Sample data!

IF OBJECT_ID('TEMPDB..#Table') IS NOT NULL

DROP TABLE #Table

CREATE TABLE #Table

(

String VARCHAR(128)

)

INSERT INTO #Table (String)

SELECT 'PO_x0020_416G_x002F_484A' UNION ALL

SELECT 'S_x0020_8292' UNION ALL

SELECT 'ABC_x0020_DEF_x0020_GHI_x002f_' UNION ALL

SELECT 'A1B2_x0020_D3E44_x0020_5FR'

Now for the code that will strip '_x0020_' and '_x002f_' from the string column:

SELECT REPLACE(REPLACE(String,'_x0020_',' '),'_x002f_',' ') REPLACED_DATA FROM #TABLE

Hope this gets you started. If not, then we are awating your clear requirements!

Cheers!