[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.

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"