5 Replies Latest reply: Sep 13, 2016 1:20 PM by Stan Bennett RSS

    filter data in where statement

    Mark Graham

      hi all,

       

      I'm trying to load only those which have A in their location.

       

      I/P:

      Number, Location

      1,909

      1,A902

      2,10812

      2,A15433

      3,A7422

      4,A901235

      4,75662

      5,A730654

       

      If it has A** and also other numbered location, i wanna exclude that.

       

       

      Req: O/P

      Numbers 3 and 5

       

      Any help is highly appreciated