Where col_x neq ''

query
RESULTSET
query
  col_1 col_2 col_3 col_4 col_5 col_6 col_7 col_8
1 Requestor Company Name Requestor Item Number Manufacturer Part Number Manufacturer Name Short Description Base Unit - UOM UOM Selling Unit Quantity EAN/UPC
2 Acme Paper & Supply Co., Inc. Acme1 NoMatch1 Essity No match, no UPC Case 1 [empty string]
3 Baumann Paper Co. Inc. Baum1 99998 Georgia Pacific SKU match Case 99 10101010101010
4 Network Services Company NSC1 NoMatch2 Kimberly-Clark Corporation UPC match Each 1 30680651550867
5 Network Services Company NSC2 09512 Kimberly-Clark Corporation Two SKU match Case 1 [empty string]
CACHED false
EXECUTIONTIME 1
SQL select * from s_sheet where COL_1 <> '' and COL_2 <> '' and COL_3 <> '' and COL_4 <> '' and COL_5 <> '' and COL_6 <> '' and COL_7 <> '' and COL_8 <> ''