begin
declare r varchar(50);
declare t varchar(20);
DECLARE BH_Len int ;
set BH_Len = 6 ;
lb_bh: loop
set t=rtrim(rand());
set r=substring(t,instr(t,'.')+1,4);
while length(r)<BH_Len do
set t=rtrim(rand());
set r=concat(r,substring(t,instr(t,'.')+1,4));
end while;
set r=left(r,BH_Len);
if not exists(select * from ims_cust_yuangong where recomcode =r ) then
leave lb_bh;
end if;
end loop lb_bh;
return r;
end