I am having a problem doing nested case statements within a select statement. The error I get is "Msg 156, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'WHEN'.
SELECT
Sales.OrderID,
Buyers.eUserid,
Buyers.Email,
CASE
WHEN Addresses.Company IS NULL OR Addresses.Company = ''...