select length(trim(req.A)), count(*)
  from tableName req
group by length(trim(req.A));

select LENGTHB(req.A) lenb, length(req.A) len, req.* from tableName req
where req.A = 'NHBBBBB1398052635902235';