eventually i forced to write a function.

i put here for friends like use :

CREATE FUNCTION [dbo].[CONVERTOR](

@string nvarchar(10)

)

returns nvarchar(10)

AS BEGIN

declare @converted nvarchar(10),

@charnvarchar(10),

@counterint,

@lengthint,

@unicodeint,

@asciiint

set @counter = 1

set @converted=N'';

set @length=LEN(@string)

while(@counter <= @length)

begin

set @char=substring(@string,@counter,1)

set @unicode= UNICODE(@char)

set @char=@unicode-1776

set @converted=@converted+@char;

set @counter = @counter + 1

end

return @converted

END

select dbo.CONVERTOR(myFiled) FROM myTable

this scalar function convert unicode to ascii 🙂

thanks all anyway