汉字生成拼音五笔 sqlserver

create procedure getpywb	
	@inputstr varchar(255), --输入汉字
	@pybz	smallint,		--0拼音 1五笔		
	@outputstr varchar(255) output	--输出
as

set nocount on

begin
declare @chzchar varchar(2),	
   	@chz	varchar(2),
   	@cpy	varchar(255),
   	@i	integer,
	@bsm	varchar(2)

	select  @inputstr=ltrim(rtrim(@inputstr))
  	select	@cpy='',
  		@chz='',
		@chzchar='',
		@i=1
	while @i<=datalength(@inputstr)
	begin
      	select @chzchar=substring(@inputstr,@i,1)
		if ascii(@chzchar)>127
      	begin
			if @chz=''
         		select @chz=@chzchar
			else
				select @chz=@chz+@chzchar
      	end
      	else if @chzchar is Null
		begin
			break
		end	
		else if ascii(@chzchar) between 48 and 57
		begin
         	select @cpy=@cpy+(case ascii(@chzchar) when 48 then 'l' when 49 then &