Like Statement for only Upper Case String 1

[dazum]

I am using CR 11
I am trying to create formula that will flag a field if it has uppercase GS in the field name
Ie. the formula reads as follows: If {Intake.Intake_Name) like "*GS*" then "Y"
This works if the field name is (GS)Smith, but it also works if the field name is Stallings(because of the last 2 letters in the name).
I would like the formula to flag the field only if the "GS" is capitalized.
I've experimented by modifying with If {Intake.Intake_Name} like UPPERCASE("*GS*"), but
it still flagged field with the name Stallings in it.

 

[BobSuruncle]

Try this:

If Instr({Intake.Intake_Name},"GS") >0 then "Y" else "N"

Bob Suruncle

 

[dazum]

Thanks Bob! That's what I needed.