4 Replies Latest reply: Aug 23, 2016 3:28 PM by Robert Winkel RSS

    where clause not working

    Robert Winkel

      I have a where clause that I am trying not to include FacID in my extract but it is not working and gives me no error?

       

       

      LOAD *;

      SQL SELECT  FacID,
      PatID,
      RxBatch,
      DispenseDt,
      RxNo,
      NDC,
      DrugLabelName,
      MOP,
      PriceCd,
      InvoiceGrp,
      IVType,
      LastModifiedBy,
      LastModifiedOn,
      MOP2,
      TtlPrice,
      TransType,
      DelivID,
      DelivDate,
      Entered,
      PharmID

      FROM Rx.dbo.Rxs

        Where FacID <> 'FORMS''MSTR''SAMPLE''TEST''TEST#2''TEST2''TEST3''TRLK''stag';