I think it's time to kill the developer :)

>I'm trying to convert this Access WHERE clause to SQL:
>
>

>WHERE (((PK_MOC.MOC_PART_NO) Not Like "*-CR" And (PK_MOC.MOC_PART_NO) Not Like "*RMA*" And (PK_MOC.MOC_PART_NO) Not Like "*RW" And 
>		  (PK_MOC.MOC_PART_NO) Not Like "*RWK") AND ((PK_MOC.MOC_OHNUMBER) Not Like "FCST*") AND ((IIf([PK_RQ]![RQ_STATUS]="C" Or 
>		  [PK_RQ]![RQ_QTY_ISS]>=[PK_RQ]![RQ_QTY_REQ],IIf([PK_RQ]![RQ_DATE_PROM]>=Date()-365 Or [PK_RQ]![RQ_DATE_REQ]>=Date()-365,True,False),True))=True) AND 
>		  ((PK_OH.OH_STATUS)<=3) AND ((PK_MOC.MOC_OHTYPE)<>"Q") AND ((PK_RQ.RQ_O_TYPE)<>"X" Or (PK_RQ.RQ_O_TYPE) Is Null));
>

>
>Here's what I have:
>
>

>WHERE ((MOC.MOC_PART_NO NOT LIKE '%-CR' AND MOC.MOC_PART_NO NOT LIKE '%RMA%' AND MOC.MOC_PART_NO NOT LIKE '%RW' AND  MOC.MOC_PART_NO NOT LIKE '%RWK') AND 
>	  (MOC.MOC_OHNUMBER NOT LIKE 'FCST%') AND 
>	  (CASE WHEN RQ.RQ_STATUS = 'C' OR RQ.RQ_QTY_ISS >= RQ.RQ_QTY_REQ THEN
>			CASE WHEN RQ.RQ_DATE_PROM >= GETDATE() - 365 OR RQ.RQ_DATE_REQ >= GETDATE() - 365 THEN 1 ELSE 0 END ELSE 0
>	   END = 1) AND 
>	  (OH.OH_STATUS <= 3) AND 
>	  (MOC.MOC_OHTYPE <> 'Q') AND 
>	  (RQ.RQ_O_TYPE <> 'X' OR RQ.RQ_O_TYPE IS NULL))
>
>

>
>I'm not getting the same rowcount back.