Forum Discussion

nkasdali's avatar
nkasdali
Microsoft Employee
8 years ago
Solved

SEARCH multi values

Hi All,   Can you help me with using the SEARCH() Function with more than one value ?   Exp : SEARCH(UserName;"SELE_MOE";"SELE_RL";"TMA";"SELE_EXP";"SELE_STD";"SELE_LIB")   Thanks
  • Greg_Deckler's avatar
    8 years ago
    Column = SEARCH("ce",[Category],1,0) || SEARCH("ware",[Category],1,0)
    
    or
    
    Column = SEARCH("ce",[Category],1,0) && SEARCH("ware",[Category],1,0)