Hot answers tagged

1

You could do something like this: CASE LEFT ( to_char (NULLIF(coalesce(0::numeric,0) - (coalesce(26776.94::numeric,0) - (coalesce(2760::numeric,0) + (coalesce(1800::numeric,0)))),0)::numeric/3600,'FM99,999,999,999.00'))::VARCHAR ,1 -- <<<---- the '1' gets the minus sign from the string! ) = '-' THEN NULL ...


Only top voted, non community-wiki answers of a minimum length are eligible