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

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"