ABS Function

The ABS function returns the absolute value of its numeric argument, returning the same data type as its argument. The query in the following example returns all orders for which a ship_charge greater than $20 was paid in cash ( + ) or as store credit ( - ).

SELECT order_num, customer_num, ship_charge 
  FROM orders WHERE ABS(ship_charge) > 20;