select
bodyitempurchasenoticedatacustomermaininfofullname,
bodyitempurchasenoticedatacustomermaininfoinn,
bodyitempurchasenoticedataregistrationnumber,
bodyitempurchasenoticedatapurchasecodename,
bodyitempurchasenoticedatapurchasemethodcode,
bodyitempurchasenoticedatapublicationdatetime,
bodyitempurchasenoticedatalotslotlotdatasubject,
nmck,
bodyitempurchasenoticedataversion
from eis_notice_223all
Where nmck Not In ('',' ') And
      nmck is Not Null
order by bodyitempurchasenoticedatacustomermaininfofullname