Can someone help me with the below code? In the below which I have put in bold it only picks up if there is information in Analysis Code 9, but not if the column is left blank. Is it possible to update the below so it picks up where the Analysis Code has been left blank because it is excluding those quotes?

SELECT DocumentNo,
DocumentDate,
DocumentTypeID,
DocumentStatusID,
SOPOrderReturnLine.ItemCode,
SOPOrderReturnLine.ItemDescription,
CustomerAccountName,
LineTotalValue,
CustomerDocumentNo,
SourceDocumentNo,
SOPOrderReturn.AnalysisCode3 [LostReason],
CASE WHEN DocumentStatusID = 2 THEN 'Won'
ELSE CASE WHEN SOPOrderReturn.AnalysisCode9 <> 'Pending' AND SOPOrderReturn.AnalysisCode9 <> ''
THEN CASE WHEN SOPOrderReturn.AnalysisCode9 = 'WON' OR SOPOrderReturn.AnalysisCode9 = 'LOST'
THEN SOPOrderReturn.AnalysisCode9
ELSE 'In Progress' END
ELSE CASE WHEN SOPOrderReturn.AnalysisCode3 = 'Not Applicable'
THEN 'In Progress'
ELSE 'Lost' END END END [QuoteStatus],
SOPOrderReturn.AnalysisCode6 [ContractRef],
DocumentCreatedBy,
SOPOrderReturn.AnalysisCode4 [Notes],
Warehouse.Name
FROM SLCustomerAccount
INNER JOIN SOPOrderReturn ON SLCustomerAccountID = CustomerID
LEFT JOIN Warehouse ON Warehouse.WarehouseID = SOPOrderReturn.WarehouseID
INNER JOIN SOPOrderReturnLine ON SOPOrderReturnLine.SOPOrderReturnID = SOPOrderReturn.SOPOrderReturnID
LEFT OUTER JOIN SOPStandardItemLink ON SOPStandardItemLink.SOPOrderReturnLineID = SOPOrderReturnLine.SOPOrderReturnLineID
WHERE SOPOrderReturn.DocumentTypeID = 3
AND Warehouse.Name = 'RAIL'
OR Warehouse.Name = 'CLARENDON'
OR Warehouse.Name = 'LOCARNO'
ORDER BY DocumentNo DESC