学步园

CREATE Function GetByteSubstring(@str varchar(8000),@len int)
returns varchar(8000)
as
begin
 declare @i int
 exec master..sp_GetMBCSCharLen @str,@len,@i out
 if @i is not null set @str=left(@str,@i)
 return(@str)
end