Convert negative data into positive data in SQL Server

Question

The current data of the table is    a   b ---------  -1   5 -11   2  -5  32  My request is to convert every data into a positive value  Unfortunately  I forgot the name of the built-in function of SQL Server that enables to convert

User · Answer

Use the absolute value function ABS   The syntax is   ABS   numeric expression

User · Answer

UPDATE mytbl SET a   ABS a  where a  lt  0

User · Answer

The best solution is  from positive to negative or from negative to positive For negative  SELECT ABS a    -1 AS AbsoluteA  ABS b    -1 AS AbsoluteB FROM YourTable  For positive  SELECT ABS a  AS AbsoluteA  ABS b   AS AbsoluteB FROM YourTable

User · Answer

An easy and straightforward solution using the CASE function  SELECT CASE WHEN   a  gt  0   THEN  a -1  ELSE  a -1  END AS NegativeA         CASE WHEN   b  gt  0   THEN  b -1  ELSE  b -1  END AS PositiveB FROM YourTableName

User · Answer

You are thinking in the function ABS  that gives you the absolute value of numeric data  SELECT ABS a  AS AbsoluteA  ABS b  AS AbsoluteB FROM YourTable

[sql] Convert negative data into positive data in SQL Server

Examples related to sql

Examples related to sql-server