Kaur, Your search will only find all of Field-B in Field-A You can search for: "%" + "DEF" + "%" in either field.
What are you trying to accomplish with this search? Joel Joel Sender * [email protected] * 310.829.5552 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kaur Sent: Monday, November 7, 2016 10:52 AM To: [email protected] Subject: Validate 2 character fields using LIKE Hi all, I need to write a qualification to validate a field in form A against a field in form B using "%" and LIKE.The qualification I have written is $fieldA$ LIKE "%"+'fieldB'+"%" , where fieldA------------- field in form A fieldB -------------field in form B fieldA= ABC DEF fieldB= XYZ DEF I need to do a partial search on the basis of 'DEF' Please help me in solving this. Thanks!! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
