Search for Descriptions Containing Strands

[Phillip]

Hi, I'm stuck trying to find descriptions containing the strand "-OBS" from our database. I have done it before I just forgot how. Here is what I have:

FOR EACH ITEM WHERE ITEM.stat = "O" AND ITEM.DESCRIPTION = "*-OBS*":

DISPLAY ITEM.ITEM.
END.

This isn't returning the values I am trying to find. Any help is appreciated. Thanks.

 

[oli]

FOR EACH ITEM WHERE ITEM.stat = "O" AND ITEM.DESCRIPTION MATCHES "*-OBS*":

 

[Phillip]

FOR EACH ITEM WHERE ITEM.stat = "O" AND ITEM.DESCRIPTION MATCHES "*-OBS*":

Thank you!

 

[jdpjamesp]

I'm guessing that this is just quick code to illustrate something, but in case it isn't, you really should be specifying the type of lock you want on your FOR EACH otherwise you will likely find the world of pain that is share locks.

 

[oli]

...or compile in a session with the -NL parameter.