按指下长度分拆中英文混合字符串！！！！

if object_id('testfunc') is not null drop function testfunc
go
create function testfunc(@Title varchar(200), @len int) returns varchar(200)---dbo.testfunc('12345678', 5)
as
begin------------------------------------------------------------1
  declare @s varchar(200)
  set @s = @Title
  if datalength(@Title) > @len
  begin------------------------------------2
    declare @i int, @n int
    set @i = 0
    set @n = @len
    while @i < @len - 1
    begin-----------------------3
        if ascii(@s) > 127  -----是汉字的话
        begin
               set @i = @i + 1
               set @n = @n - 1
        end
---------------- 上下分开---------------
         set @i = @i + 1
         set @s = right(@s, len(@s) - 1)
    end-------------------------3
    if @i = @len or ascii(@s) < 128 
      set @s = left(@Title, @n) -------------针对‘123456’形式的串
    else
      set @s = left(@Title, @n - 1)-----针对‘1234字’
  end--------------------------------------2
  return(@s)
end---------------------------------------------------------------1
go
select 1 as id, dbo.testfunc('12345678', 5) as title
union select 2, dbo.testfunc('1234五六', 5)
union select 3, dbo.testfunc('1二三四五六', 5)
union select 4, dbo.testfunc('一二3四五六', 5)
union select 5, dbo.testfunc('一二三四五六', 5)
union select 6, dbo.testfunc('一', 5)
/*
id      title
-------------
112345
21234
31二三
4一二3
5一二
6一
*/
drop function testfunc

select 1 as id, dbo.testfunc('12345678', 5) as title
union select 2, dbo.testfunc('1234五六', 5)
union select 3, dbo.testfunc('1二三四五六', 5)
union select 4, dbo.testfunc('一二3四五六', 5)
union select 5, dbo.testfunc('一二三四五六', 5)
union select 6, dbo.testfunc('一', 5)
/*
id      title
-------------
1       12345
2       1234
3       1二三
4       一二3
5       一二
6       一
*/
drop function testfunc