Operator - STARTS WITH - how to do multiple ?

[markajem]

My present selection formula allows for one letter of the alphabet. I would like to include 3 or 4 other ones but really don't know the syntax of how to do muliple letters within this formula.

This shows I don't want records where this field starts with a "w"

not ({BINMSTR.BINLABEL} startswith "w&quot

Would like it to be where it won't show records if the field starts with "w", "r" and "g"

not ({BINMSTR.BINLABEL} startswith (in ["w", "r", "g"]))

Would this be correct or even close?

Thanks



Mark
Email: markanas333@hotmail.com

 

[markajem]

Okay, never mind. I guess my brain is just not awake yet. Sometimes you look too hard for a solution when it is staring you in the face.

Correct way:


not ({BINMSTR.BINLABEL} startswith ["g", "r", "w"])


sorry to be such a "DUH" today.

Thanks anyway.

Mark
Email: markanas333@hotmail.com