The "Where" command

[antaeuslogan]

How do I search multiple field values with the "where" command. I am trying to search  multiple field values that are greater than the number zero, and then have them listed in multiple rows within one column. I am not sure of how to format this in the SPL or know if this is even possible with the "where" command.  If you know of a more efficient way of solving this problem with another SPL command please let me know. Also, if there is a better command to use to solve this problem can you please display the correct format of the command for best results. Thank you in advance for your help!!

[richgalloway]

Please share your data (anonymized, if necessary), your current search, and a mock-up of the desired results.

The where command can search using complex expressions.

| where (foo>0 OR bar>0 OR baz>0)