[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: Validate 2 character fields using LIKE



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  *   JDSENDER@EARTHLINK.NET  *  310.829.5552

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur
Sent: Monday, November 7, 2016 10:52 AM
To: arslist@ARSLIST.ORG
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"