PCB MS SQL Lowercase to uppercase

Because SQL Server allows lowercase entry, causing the database to exist in lowercase, in data integration to MES or ERP times error, Oracle requires capitalization to cause,

To be converted to uppercase, all lowercase data can be queried and updated by the following statement.

SELECT *  fromPpeflowWHEREPdctno like '%[a-z]%'COLLATE Chinese_prc_bin and LEN(Pdctno)= TenUpdatePpegeneralSETPdctno= UPPER(Pdctno)WHEREPdctno like '%[a-z]%'COLLATE Chinese_prc_bin and LEN(Pdctno)= Ten

PCB MS SQL Lowercase to uppercase