Where statement

[#1]

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

[swuehl]

Have a look at

Escape sequences

[#3]

I cant use the fixed character.  Room numbers are variable fields.

I also tried 

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

[sunny_talwar]

May be with WildMatch

Where WildMatch("Comment", '*INACTV? to ?ACTIVE*');

[#5]

[sunny_talwar · Accepted solution]

You are using this in SQL.... try this

Where Msg Like '%INACTV% to %ACTIVE%';