LIKE or CONTAINS Conditions in ER

[jimmymac]

In E/R in a table trigger I need to compare a variable to see if it contains a T. The values in that field might be R, RT, RTX, etc. plus combinations that might be coming in the future. I would a condition that would work in the future no matter what, so long as it contains a T. However, E/R if statements seem to only allow you to select =, >, etc. Anyone familiar with an obscure way to get this to work?

Thanks.

 

[barrier]

Open Business Function Search, enter *InString* in Function Name QBE and click find. You will find several BSFNs that will do what you want.

 

[DBohner-(db)]

You want to look for the 'Find a Character in a String' function. I can't provide the function object ID off the top of my head - but, it's probably the best resolution for what you are defining.

(db)

 

[Zaki Ahmed]

There is a business function "SearchStringForSpecificCharacter" (B3200970). This may come handy to what you are trying to do.