your data

CREATE TABLE yourtable(
   name VARCHAR(100) NOT NULL 
  ,qty  INTEGER  NOT NULL
);
INSERT INTO yourtable(name,qty) VALUES 
('QMORIASDWAD',1),
('QMORIASDWAD',3),
('QMORIASDWAD',4),
('QMORIASDWAD',5),
('QMORIASDWAD',6),
('QMORIASDWAD',7),
('QMORIASDWAD',8);

Just use Concat , Lower and Left function

SELECT 
CONCAT(LOWER(left(name,2)),2) name,
qty 
FROM YourTable

dbfiddle

Based on your query,you can use with

with t as (
  SELECT 
    DISTINCT name, 
    qty 
  FROM 
    db 
  WHERE 
    cast (prod_date AS DATE) = cast (
      getdate () AS DATE
    ) 
    and name <> 'asd'
) 

SELECT 
CONCAT (LOWER(left(NAME, 2)),2) NAME
,qty
FROM t