SQL Upper Case and Lower Case String Conversion

Posted on by

SQL Convert String to Upper Case

postcode: cf64 3pg

update customer                
set    postcode = UPPER(postcode)   

postcode: CF64 3PG

SQL Convert String to Lower Case

postcode: CF64 3PG

update customer                
set    postcode = LOWER(postcode)   

postcode: cf64 3pg
Posted in SQL.