Using MS SQL, I like to replace the information in the OEM_Description column when the column Item translation (IT).Description is NULL and when the language setting of the customer C.[Language Code] is English (ENG) into the original item description (I.[Description])
I have come up to this query:
SELECT "OEM_Description" = CASE WHEN (C.[Language Code] = 'ENG' and IT.[Description] = NULL) THEN I.[Description] ELSE IT.[Description] END, C.Name as Customer_Name
However the information is only being replaced if I test on "C.[Language Code] = 'ENG'" as soon as i add the test for IT.[Description] = NULL nothing is replaced anymore.
What do I wrong?