select * from tbltest where Rtrim(Ltrim(Subject)) in ('Call')
in the above query you are using the column
Subject
whereas in the below you are using the column
Status
select * from tbltest where Rtrim(Ltrim(Status)) in ('Completed')
Please make sure your column names are correct ??