Question1Replies16Views×Close popoverNikolaos Alexiou (NikolaosA) BAH BAH US View Profile NikolaosA Member since 2020 3 posts BAH Posted: 4 weeks 1 day agoLast activity: 4 weeks 1 day agoPosted: 22 Dec 2020 13:51 ESTLast activity: 22 Dec 2020 20:36 EST TableView and LIKE Filter issueI have a LookupTable with Field1 and Field2 columns.I am trying to filter only the values that include characters B or CThis is the WHERE clause I tried to apply:Field2 LIKE '[BC]' However, when automation executes ApplyFilter I get the following Error:Error executing link in Automation: Automation1 - From: Windows_Form1.btnGetCurrentValue.Click To: Windows_Form1.tableView1.ApplyFilter()Error in Like operator: the string pattern '[BC]' is invalid.I also tried using an input parameter for passing BC and I am still getting same message.I have attached a screenshot of the setup. Is the above syntax for the filter not supported In Robotics? Per discussion here: https://collaborate.pega.com/question/filter-data-coming-excel-sheet-pega-robotics-studio, I reviewed https://www.csharp-examples.net/dataview-rowfilter/ but did not see any special exceptions to my expression.I am using Pega Robot Studio 220.127.116.11.Thank you,Nikolaos Pega Robotic Desktop Automation 19.1 Robotic Process Automation Technology Services Solutions Engineer ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Posted: 4 weeks agoPosted: 22 Dec 2020 20:36 EST×Close popoverJohn Talbot (TALBJ) PEGA Sr. System Architect Pegasystems Inc. JP View ProfileTALBJ PEGA replied to NikolaosAI think this needs 2 comparisons - using the csharp syntax to find B or C anywhere in the strings this would be:Field2 LIKE '*B*' OR Field2 LIKE '*C*'Note: some varients of SQL use * for the wildcard, others use %. This might depend upon your backend DB.