This stored sql procedure is used to replace a special character (or string) of your field with another string.
See:http://wiki.coolorange.com/index.php?title=documentAnalyzer/5._Migration_PSP_to_Vault/Tips_&_Tricks for more details about the usage.
You can call the procedure like this:
DECLARE @return_value int, @value nvarchar(2000)
EXEC @return_value = [dbo].[cOReplaceFieldValue]
@value = @value OUTPUT,
@fieldValue = N'hallo/hallo',
@toReplace = N'/',
@replaceWith = N''
SELECT @value as N'@value'
This will output this: 'hallo_hallo'
CREATE PROCEDURE [dbo].[cO_ReplaceFieldValue] (@value NVARCHAR(2000) OUTPUT, @fieldValue varchar(200),@toReplace varchar(200),@replaceWith varchar(200))
AS
BEGIN
SET @value = null
select @value = ISNULL(REPLACE(@fieldValue, @toReplace, @replaceWith), '')
RETURN
END