There has been a number of requests on ad-hoc lookups of web sales order records (for location 513) that have specific text in the data field called item_note9 (or release status). The query attached enables this. The query can be easily modified to search for different phrases in the data field item_note9 by changing text in blue shown below in the "where clause" to what is desired:
WHERE B.ITEM_NOTE9 LIKE '%3PL%PROCESSING%'
In the above example, the query searching for item_note9 that contain the strings "3PL" and "PROCESSING". The % sign is used as a wildcard.
There are often similar requests that ask for a search for SO records with item_note9 equal to "WAITING - Insufficient available to ship: 0". By replace the string in the where clause of the same query with this will provide the needed result.