Calculated Fields
3
Concatenating Fields
Removing Unwanted Spaces
Using Aliases
Mathematical Calculations
CASE WHEN clause
Case Changes
Default value
SELECT
UPPER
(CompanyName) UpperName,
LOWER
(CompanyName) LowerName
FROM
Customers
LIMIT
1000