Forum Discussion

nkasdali's avatar
nkasdali
Icon for Microsoft Employee rankMicrosoft 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
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    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)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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)