CREATE OR REPLACE VIEW SD_HOSPITAL.VW_BQ_SYKPNR
 (
 YZID00, YPYFMC, YPMC00, YPMCGG, YPGG00, YYZF00, PCMC00, YZNR01

 )
 AS 
select t1.yzid00,ypyfmc,t1.YPMC00,t1.YPMC00||'['||t1.YPGG00||']' ypmcgg,
decode(t1.YZCLLB,'×Ô±¸Ò©','[±¸]')||' '||DECode(Sign(t1.MCSL00-1),-1,'0','')||t1.mcsl00||t1.JLDW00 YPGG00,Substrb(t2.YYZF00,1,100)yyzf00,t2.PCMC00
,rpad(t1.YPMC00||'['||t1.YPGG00||']',20,' ')|| t1.yznr01 yznr01
from BQ_YPYZMX t1, BQ_YPYZ00 t2 WHERE t1.YZID00=t2.YZID00
/