If formula to find specific values in a string field?

[pokerace]

C10

I am trying to write an if statement that can check a string field for a certain combination of charatcets, and then return an assigned string value if it is true, and another assigned value if not. Something like below but I can't get the proper syntax.

If InStr({StringField}, "ABC") then "Value 1"
else "Value 2"

Thanks.

 

[synapsevampire]

Oooooooh, soooo close, try:

If InStr({StringField}, "ABC") > 0 then
"Value 1"
else
"Value 2"

-k

 

[lbass]

You almost had it:

If InStr({StringField}, "ABC") > 0 then "Value 1"
else "Value 2"

-LB

 

[pokerace]

Thanks.