SQL substring 2

--substring
SELECT TOP 11 (SELECT CONCAT ('Lab_OR',
             (SELECT SUBSTRING (OrderID,4,len (OrderID)-3))))
             AS 'New OrderID', Cust_Name, Address, ItemName, Price
  FROM Customers C
  INNER JOIN Orders O
  ON C.CustomerID=O.CustomerID
  INNER JOIN Items I
  ON O.ItemID = I.ItemID
  WHERE I.Price  >
  (SELECT TOP 1
    I.Price
  FROM Customers C
  INNER JOIN Orders O
  ON C.CustomerID = O.CustomerID
  INNER JOIN Items I
  ON O.ItemID = I.ItemID
  WHERE Cust_Name = 'Badang'
  )
  ORDER BY Price