ALTER FUNCTION [camera].[replace_msword_chars]
(
	-- Add the parameters for the function here
	@col_value varchar(8000)
)
RETURNS varchar(8000)
AS
BEGIN
	-- Declare the return variable here
	DECLARE @replaced_value varchar(8000)

	-- Add the T-SQL statements to compute the return value here
	SET @replaced_value = replace(replace(replace(replace(
		  @col_value, '’', char(39)),
		  '“', char(34)),
		  '”', char(34)),
		  '–', char(45))

	RETURN @replaced_value
END