select id,nr,bt=case when (len(bt)>=18) then rtrim(substring(bt,1,18))+'...' when (len(bt)<18) then bt end from d_xgnr where lb=1
如果改写成access该如何写？