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'*;