Stuck SOP Records without a Valid Batch

Client had an issue with users stuck in SOP. This can occur if the username is the batch number. These batches will use lower case letters. To identify any batches with all lower case letters I used this script that identifies lower case.

select BACHNUMB,* from SOP10100 where BACHNUMB COLLATE Latin1_General_CS_AI=Lower(BACHNUMB)