Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Like Statement for only Upper Case String 1

Status
Not open for further replies.

dazum

Technical User
Apr 6, 2011
57
US
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.
 
Try this:

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


Bob Suruncle
 
Thanks Bob! That's what I needed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top