How to change lowercase course IDs to uppercase in the Course table (CRS) using SQL.
Changes cascade to GRD, GRH, CAR, HIS, MST, and SMS
Modified on: Mon, Nov 25, 2024 at 9:49 AM
How to change lowercase course IDs to uppercase in the Course table (CRS) using SQL.
UPDATE CRS
SET CN = UPPER(CN)
WHERE UPPER(CN) COLLATE Latin1_General_CS_AS <> CN
Changes cascade to GRD, GRH, CAR, HIS, MST, and SMS
Did you find it helpful? Yes No
Send feedback