6 Replies Latest reply: Jul 22, 2016 8:02 PM by Marco Wedel RSS

    If function searching for case sensitive text

    Karen Mujeyi

      Hello,

       

      I have a set of data that I need to qualify based on the text of a field and it is case sensitive.  The current load script is pulling ANYTHING that starts with clinical and I need it to recognize CLINICAL all in caps only.

       

      Load

      Metric,

      Type,

      Title,

      Date,

       

      If(Title LIKE 'CLINICAL*' and Metric = 'Letters', 'Include', 'Exclude') as Status

       

      From

      [C:\Reports\Reports_12202015.xls]

      (ooxml, embedded labels, table is Sheet1);


      How can I get it to be case sensitive?  Any help is greatly appreciated.