returns nvarchar(4000)

as

begin

declare @i int

declare @str nvarchar

declare @result nvarchar(4000)

set @result = ''

set @str = ''

set @i=1

             while @i <= len(@a)

             begin

                        if unicode(substring(@a,@i,1)) = 12288

                        begin

                                 set @str = ''

                        end

                        else

                                begin

                                           set @str = nchar(unicode(substring(@a,@i,1))-65248)

                                end

           set @i = @i + 1

           set @result = @result + @str

           end

return @result

end

전각을 반각으로 처리하는 함수인데

함수호출을 어케 해야하는 건지요?

예를 들어서 "전각문자테스트"란 테이블에 "명칭"이란 필드에 데이터가 10개 이상