Dear Igor Tandetnik, You guessed it perfectly right, the partner_sku is comprised of and combined with '-', the former part is family of items and the latter one is the variant. What I was trying to do is filtering those values based on their item family say 'A1012', 'A207' etc. Thank you so much. It worked like a charm. I seriously implemented your suggestion of having a separate column (actually a separate table) having item's family. Here are the steps I performed; sqlite> .import catalogue.csv ctl sqlite> CREATE TEMP TABLE item AS SELECT partner_sku , SUBSTR ( partner_sku , 1 , INSTR ( partner_sku , '-' ) - 1 ) AS item FROM ctl; sqlite> SELECT partner_sku, sku_child FROM ctl INNER JOIN item USING (partner_sku) WHERE item IN ( 'A1012' , 'A207' , 'KH108', 'KH247' , 'KH132' , 'KH134' ); And here is the result; partner_sku,sku_child A1012-20_BGN,N31450486A A1012-20_BLK,N31450462A A1012-20_BLU,N31450468A A1012-20_ROS,N31450474A A1012-20_PNK,N31450480A A1012-24_BGN,N31450487A A1012-24_BLU,N31450469A A1012-24_ROS,N31450475A A1012-24_PNK,N31450481A A1012-24_BLK,N31450463A A1012-28_BLU,N31450470A A1012-28_BGN,N31450488A A1012-28_PNK,N31450482A A1012-28_ROS,N31450476A A1012-28_BLK,N31450464A A1012-3_BGN,N31450490A A1012-3_BLU,N31450472A A1012-3_BLK,N31450466A A1012-3_ROS,N31450478A A1012-3_PNK,N31450484A A1012-32_ROS,N31450477A A1012-32_BLU,N31450471A A1012-32_BGN,N31450489A A1012-32_BLK,N31450465A A1012-32_PNK,N31450483A A1012-4_ROS,N31450479A A1012-4_BLK,N31450467A A1012-4_BLU,N31450473A A1012-4_PNK,N31450485A A1012-4_BGN,N31450491A A207-20_BGN,N31450456A A207-20_ROS,N31450444A A207-20_BLU,N31450438A A207-20_PNK,N31450450A A207-20_BLK,N31450432A A207-24_BLK,N31450433A A207-24_BGN,N31450457A A207-24_ROS,N31450445A A207-24_BLU,N31450439A A207-24_PNK,N31450451A A207-28_BLK,N31450434A A207-28_BGN,N31450458A A207-28_ROS,N31450446A A207-28_BLU,N31450440A A207-28_PNK,N31450452A A207-3_ROS,N31450448A A207-3_BLK,N31450436A A207-3_BLU,N31450442A A207-3_BGN,N31450460A A207-3_PNK,N31450454A A207-32_BLU,N31450441A A207-32_BGN,N31450459A A207-32_BLK,N31450435A A207-32_ROS,N31450447A A207-32_PNK,N31450453A A207-4_BLU,N31450443A A207-4_BGN,N31450461A A207-4_BLK,N31450437A A207-4_ROS,N31450449A A207-4_PNK,N31450455A KH108-20_BLU,N43895442A KH108-20_BLK,N12740940A KH108-20_BGN,N43895448A KH108-20_BRN,N43895436A KH108-20_BRW,N12740943A KH108-20_MRN,N12740949A KH108-20_NVY,N12740946A KH108-24_BGN,N43895449A KH108-24_BLU,N43895443A KH108-24_BLK,N12740941A KH108-24_BRN,N43895437A KH108-24_MRN,N12740950A KH108-24_NVY,N12740947A KH108-24_BRW,N12740944A KH108-28_BGN,N43895450A KH108-28_BLK,N12740942A KH108-28_BLU,N43895444A KH108-28_BRN,N43895438A KH108-28_MRN,N12740951A KH108-28_NVY,N12740948A KH108-28_BRW,N12740945A KH108-3_BGN,N43895452A KH108-3_BLU,N43895446A KH108-3_BRN,N43895440A KH108-32_BRN,N43895439A KH108-32_BGN,N43895451A KH108-32_BLK,N40910565A KH108-32_BLU,N43895445A KH108-32_BRW,N40910566A KH108-32_NVY,N40910567A KH108-4_BLU,N43895447A KH108-4_BRN,N43895441A KH108-4_BGN,N43895453A KH132-20_COF,N18602990A KH132-20_NVY,N18602992A KH132-20_BLK,N18602991A KH132-24_BLK,N18602994A KH132-24_COF,N18602993A KH132-24_NVY,N18602995A KH132-28_COF,N18602996A KH132-28_BLK,N18602997A KH132-28_NVY,N18602998A KH132-3_BLK,N18602988A KH132-3_COF,N18602987A KH132-3_NVY,N18602989A KH134-20_BLK,N18603015A KH134-20_SIL,N18603016A KH134-20_BGN,N42588980A KH134-20_NVY,N18603014A KH134-24_BGN,N42588981A KH134-24_BLK,N18603018A KH134-24_SIL,N18603019A KH134-24_NVY,N18603017A KH134-28_BLK,N18603021A KH134-28_BGN,N42588982A KH134-28_SIL,N18603022A KH134-28_NVY,N18603020A KH134-3_BLK,N18603012A KH134-3_BGN,N42588983A KH134-3_SIL,N18603013A KH134-3_NVY,N18603011A KH247-20_NVY,N18603058A KH247-20_BRW,N43895454A KH247-20_BLK,N18603057A KH247-20_BGN,N43895466A KH247-20_BRN,N18603055A KH247-20_MRN,N18603056A KH247-20_BLU,N43895460A KH247-24_BRW,N43895455A KH247-24_BLK,N18603061A KH247-24_BRN,N18603059A KH247-24_MRN,N18603060A KH247-24_BGN,N43895467A KH247-24_NVY,N18603062A KH247-24_BLU,N43895461A KH247-28_BRW,N43895456A KH247-28_BLU,N43895462A KH247-28_BLK,N18603065A KH247-28_NVY,N18603066A KH247-28_BRN,N18603063A KH247-28_BGN,N43895468A KH247-28_MRN,N18603064A KH247-3_BRW,N43895458A KH247-3_BLU,N43895464A KH247-3_BGN,N43895470A KH247-32_BLU,N43895463A KH247-32_BGN,N43895469A KH247-32_BLK,N18603069A KH247-32_BRW,N43895457A KH247-32_NVY,N18603070A KH247-32_MRN,N18603068A KH247-32_BRN,N18603067A KH247-4_BRN,N18603051A KH247-4_BRW,N43895459A KH247-4_BLU,N43895465A KH247-4_BGN,N43895471A KH247-4_BLK,N18603053A KH247-4_NVY,N18603054A KH247-4_MRN,N18603052A