select top 1 ishome=case when len('s')=0 or 's'='index' then '0' else case when len('')=5 then upper('s') else case when len('uIYGeno811')>=8 then '2'+upper('s') else '-1' end end end,oid=c_class,nid='uIYGeno811',code=upper('s'),* from sh_class where ''=c_class or 's'='index' or (left(c_class,1)=case when 's'='e' then 'n' else 's' end and len('')=0)<BR>