need help with Case
I have a field named Diagnosis that contains free text. example: Other closed fractures of distal end of radius (alone); Scaphoid fracture of wrist
I am trying to create a field named Body Area that contains text based on what's entered in Diagnosis (e.g., if diagnosis contains "wrist", Body Area would display "wrist".)
I tried testing it out with Case ( DIAGNOSIS = "*wrist*" ; "wrist" ; DIAGNOSIS = "*hand*" or "*finger*"; "hand"; "" ) but it's not doing anything. I tried with and without the wildcard operators.
Thanks for any help-