Contains instead of Equal in Case Statement

[shaferam]

How would I edit this case in a calculated field to CONTAIN the word Ambulatory instead of EQUAL it?  Thanks!

CASE
WHEN [@field:RequirementType] = "Ambulatory" and [@field:Number_Of_Weeks] = 4 THEN 4
WHEN [@field:RequirementType] = "Ambulatory" and [@field:Number_Of_Weeks] = 2 THEN 2
END

 

[Tubby]

Use LIKE

CASE
WHEN [@field:RequirementType] LIKE '%Ambulatory%' and [@field:Number_Of_Weeks] = 4 THEN 4
WHEN [@field:RequirementType] LIKE '%Ambulatory%' and [@field:Number_Of_Weeks] = 2 THEN 2
END

The % is wildcard that defines the position of the string  that you are looking for. Example : 'Ambulatory%' searches for values that starts with Ambulatory. '%Ambulatory' searches for values that ends with it. Adding it on both sides checks for the value in any position.

 

[Tubby]

You can refer to this w3schools article: https://www.w3schools.com/sql/sql_like.asp

[shaferam]

16 hours ago, Tubby said:

Thank you so much!!