create function getLastLetterPosition 
 (@str nvarchar(100)) 
 returns int 
 as 
 begin 
 	declare @i int 
 	set @i=1 
 	while unicode(substring(@str,@i,1)) <255 
 		set @i=@i+1 
 	return @i-1 
 end 
 go 
 create table tb(书名 nvarchar(20)) 
 insert into tb select 'abc 你是谁' 
 union all select 'bcd 怎么样' 
 union all select 'bdf 为什么' 
 go 
 select left(书名,dbo.getLastLetterPosition(书名)) as 英文书名 from tb 
 /* 
 英文书名 
 -------------------- 
 abc  
 bcd  
 bdf  
  
 (3 行受影响) 
  
 */ 
 go 
 drop function getLastLetterPosition 
 drop table tb