SQL 判断中英文

ALTER VIEW [dbo].[V_MyFriendsZhiNengShow] AS select * from(  select myf.*,cast(Pro.firstName as nvarchar(30))+  cast(Pro.LastName as nvarchar(20))+' : '+cast(snsUser.email as nvarchar(50)) as name,Pro.LastName,Pro.firstName,snsUser.email,  case (select PATINDEX('[a-z]' COLLATE Chinese_PRC_CI_AS,left(Pro.LastName,1)))  when 1 then cast(Pro.firstName as nvarchar(20))+cast(Pro.LastName as nvarchar(20))   when 0 then cast(Pro.LastName as nvarchar(20))+cast(Pro.firstName as nvarchar(20))   end as FullName  from dbo.SnsMyFriends as myf  left join dbo.SnsUserAccount as snsUser on myf.friendID=snsUser.ID  left join dbo.SnsUserProfile as Pro on snsUser.ID=Pro.UserID  )t

GO

select  reverse(substring(reverse(name),patindex('%[吖-座]%',reverse(name)),len(name)))  ,name from V_MyFriendsZhiNengShow

select PATINDEX('[a-z]' COLLATE Chinese_PRC_CI_AS,'a')

select PATINDEX('[吖-咗]' COLLATE Chinese_PRC_CI_AS,'啊')

select left(N'eg',1)