--返回指定字符串左边指定字节长度的字符串
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[f_getleft]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[f_getleft]
GO
CREATE function f_getleft(@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
go
1,建自定义函数
CREATE function getleft(@a Nvarchar(2000),@getLen int)
returns Nvarchar(2000)
as
begin
declare @i int,@len int,@b Nvarchar(2000)
set @i=1
set @b=''
set @len=0
while @i<=len(@a) and @len<@getlen
begin
if ascii(substring(@a,@i,1))>128
set @len=@len+1
set @b=left(@a,@i)
set @len=@len+1
set @i=@i+1
end
return @b
end