We walk in the dark places no others will enter
We stand on the bridge and no one may pass

CREATE TABLE #Fields (model_size INT, model_type VARCHAR(10), actual_qty INT,process_qty, order_type Char(3) )
-- display all fields + modelsize where ordertype='X'
Select  model_size, model_type, actual_qty, process_qty, order_type from #Fields
Where order_type = 'Some X' 

CREATE TABLE #Fields
  (
     MODEL_SIZE  INT,
     MODEL_TYPE  VARCHAR(10),
     ACTUAL_QTY  INT,
     PROCESS_QTY INT,
     ORDER_TYPE  CHAR(3)
  ) 

insert into #Fields values (1,'abc',10,5,'t'),
(2,'bcd',10,5,'y'),(3,'abcd',10,5,'z')

SELECT MODEL_SIZE,
       MODEL_TYPE,
       ACTUAL_QTY,
       PROCESS_QTY,
       ORDER_TYPE,
       ( CASE
           WHEN ORDER_TYPE = 't' THEN 'new'
           ELSE 'existing'
         END )AS attribinfo
FROM   #Fields