This content has been marked as final. Show 5 replies
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'*;