NOT Like或NVARCHAR字段中的<>也过滤掉Null - SQL Server 2008

我有一个专栏StatusCode.我想过滤掉文本Complete而不过滤掉NULL值.

我正在使用SSMS来编写我的查询,如果我使用<>或者NOT LIKE,它也会过滤掉这些NULL值.

SELECT TOP (1) 
   dbo.WOO.WOO_StatusCode, dbo.WOO.WOO_WorkCenterID
FROM 
   dbo.WOO 
LEFT OUTER JOIN
   dbo.WKE ON dbo.WOO.WOO_RecordID = dbo.WKE.WKE_WOO_RecordID 
LEFT OUTER JOIN
   dbo.WKO ON dbo.WOO.WOO_WorkOrderID = dbo.WKO.WKO_WorkOrderID
WHERE     
   (dbo.WKO.WKO_WorkOrderID = @WorkOrder) 
   AND (NOT (dbo.WOO.WOO_StatusCode  LIKE  N'Complete'))
ORDER BY 
   dbo.WKE.WKE_LabStopTime DESC

我需要返回NULL,b/c其他连接表仍然可以返回与记录相关的有用信息.

基本上,如何在NVARCHAR不省略NULL值的情况下过滤列？