登录名-特殊拼音处理

select name,login_name,fn_getpy_1(name),fn_getpy_1(case
when instr(name,'曾')>0 then REPLACE(name,'曾','zeng')
when instr(name,'兴')>0 then REPLACE(name,'兴','xing')
when instr(name,'毛')>0 then REPLACE(name,'毛','mao')  
when instr(name,'仇')>0 then REPLACE(name,'仇','mao')  
else name end)||substr(login_name,instr(login_name,'@') )as new_login_name
from isc_user where name like '%毛%' or name like '%兴%' or name like '%曾%' or name like '%仇%'