FILTERING STRINGS

[ejastia]

Hi!

I need to filter {ARCUS.NAMECUST)that contains "wood" only. What formula will I use? Thanks.

 

[Charliy]

WOOD" IN {ARCUS.CUSTNAME}
Will give you all names that contain the string "WOOD" regardless of whether it's part of the first or last name.

 

[kray4660]

I do not believe the syntax is correct. But {ARCUS.CUSTNAME} like "*WOOD*" should work.

 

[AndyMc]

Either would work - although I would use the uppercase function to catch all. Charily's method is my go-to choice:

"WOOD" IN ucase({ARCUS.CUSTNAME})

 

[ejastia]

I tried all and they worked. Thank you!!