Get startedGet started for free

Calculating the absolute value

The Shipments table contains some bad data. There was a problem with the scales, and the weights show up as negative numbers. In this exercise, you will write a query to convert all negative weights to positive weights.

This exercise is part of the course

Intermediate SQL Server

View Course

Exercise instructions

Write a query that converts all the negative values in the DeliveryWeight column to positive values.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Return the absolute value of DeliveryWeight
SELECT DeliveryWeight,
       ___(___) AS AbsoluteValue
FROM Shipments
Edit and Run Code