SSIS expression to SQL statement

Question

I am trying to convert "Derived Columns" Expressions to SQL statements to be able to add and replace column values and names.

I am having some issues in finding the correct help to understand nested formulas in SSIS.

Formula i have in SSIS is,

[A] == 0 || ISNULL([A]) ? -1 :  [A]

How do i write this in a SQL statement?

Answer 1

Some thing like this

CASE WHEN [A] = 0 OR [A] IS NULL THEN -1  ELSE [A] END