SET @pysx='';
SET @len=CHAR_LENGTH(zw);
SET @i=1;
WHILE @i<=@len DOSET @hz=SUBSTR(zw,@i,1);
SELECT jp INTO @jp FROM hzpyb WHERE hz=@hz;
SET @pysx=CONCAT(@pysx,@jp);
SET @i=@i+1;END WHILE;
RETURN @pysx;
SET @pysx='';
SET @len=CHAR_LENGTH(zw);
SET @i=1;
WHILE @i<=@len DOSET @hz=SUBSTR(zw,@i,1);
SELECT jp INTO @jp FROM hzpyb WHERE hz=@hz;
SET @pysx=CONCAT(@pysx,@jp);
SET @i=@i+1;END WHILE;
RETURN @pysx;