begin;

select 
	borrower_attributes.borrowernumber,
	attribute,
	replace(attribute,'\r\n','') as sid,
	length(replace(attribute,'\r\n','')) as len,
	userid
from borrower_attributes
join borrowers on (borrower_attributes.borrowernumber = borrowers.borrowernumber)
where code = 'RFID_SID'
and replace(attribute,'\r\n','') != attribute
;

update borrower_attributes set
	attribute=replace(attribute,'\r\n','')
where code = 'RFID_SID'
and replace(attribute,'\r\n','') != attribute
;

