5 Replies Latest reply: Mar 14, 2017 12:48 PM by Sunny Talwar RSS

    Where statement

    Robert Winkel

      I am trying to use a where statement that will only pull in comments with this exact spelling someplace in the comment.

      Below is how the statement looks.

       

      The following changes were made:

          Room from '207' to '203'

          PatStatus from 'I' to 'A'

          StatusNameCd from 'INACTV' to 'ACTIVE'

       

      I know I need how to us the below to only load with the data below.

       

      'INACTV' to 'ACTIVE'

       

       

      Where "Comment" = *'INACTV' to 'ACTIVE'*;