If you want to set all values in a field to lower case use the lcase command.  For example, if I wanted to set the document_no in the ar posted file to lower case I would type: 


update "ar_posted_trxs" set document_no = lcase(document_no);