'ABS' is not a recognized function name.

[dba112233]

SUM(
CASE WHEN rmstrancde IN ('50','51','52','53')
THEN (0 - ABS(DISTINCT rmstranamt))
WHEN rmstrancde IN ('55','56','57','58')
THEN ABS(DISTINCT rmstranamt)
ELSE
DISTINCT rmstranamt
END
) As rmstranamt

ERROR: 'ABS' is not a recognized function name.

 

[vongrunt]

Move DISTINCT outside ABS()...

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SQLDenis]

What kind of stupid error message is this?

select abs(distinct-500)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/