Assume Authors.State is a VARCHAR2 column containing the three values below.
SELECT UPPER(State) AS UpperState FROM Authors;
SELECT LOWER(State) AS LowerState FROM Authors;
- Give both calculated values for each source value.
- Explain what happens to NULL.
- State whether either query changes Authors.State.
Use the sample ASCII state abbreviations. Do not assume the same case-conversion rules for every writing system.