question

Hi I need to remove carriage return in a column. But one company have a lot of chinese character, and my function return ??? instead. Function: create FUNCTION [dbo].[fnc_RemoveCharacters_New](@Text nvarchar(max)) RETURNS nvarchar(4000) AS BEGIN -- Declare the return variable here DECLARE @ReturnText nvarchar(4000) DECLARE @cnvText nvarchar(4000) SET @cnvText = cast(@Text as nvarchar(4000)) SET @ReturnText = convert(nvarchar(4000),REPLACE(@cnvText, ';',':')) SET @ReturnText = convert(nvarchar(4000),REPLACE(@ReturnText, char(13),'')) /*Carriage return */ SET @ReturnText = convert(nvarchar(4000),REPLACE(@ReturnText, CHAR(9),'')) /*Horozontal tab replaced with 3 spaces*/ SET @ReturnText = convert(nvarchar(4000),REPLACE(@ReturnText, CHAR(10),'')) /*Line feed*/ RETURN @ReturnText end go Test: declare @test2 nvarchar(100) declare @test nvarchar(100) set @test = '锥重 型）1G2686' set @test2 ='锥孔平滑轴承钻夹头（重型）1G2686' select dbo.fnc_RemoveCharacters_New(@Test) AS test, dbo.fnc_RemoveCharacters_New(@Test2) as Test2 Result: Test = ?? ?)1G2686 Test2 = ?????????(??)1G2686 So function removes carriage return but also dos not recognize the chinese characters ?? Hope someone have an idea :-) BR Jan Update: By mistake I had written @Text varchar(max) it was @Text nvarchar(max) And the result is equal Result: Test = ???)1G2686 Test2 = ?????????(??)1G2686