DECLARE @searchString VARCHAR(1500);
SET @searchString = '03/09/2017 07:52 AM | Lastname, Firstname | Completed - irrelevant note.';
SELECT CASE
    WHEN @searchString LIKE '[0-9][0-9]/[0-9][0-9]/201[0-9]%[AP]M%|%'
    THEN...

please read and respond accordingly......saves us all time and you get tried and tested answers.

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

just a thought....it may help explain 

SELECT c.id_product,
   SUM(COALESCE(c.received_qty, c.ordered_qty)) AS Total,
   c.id_cart,
   p.id_purchase,
   p.id_department
FROM Cart_Item AS c
  LEFT OUTER...

pity the OP @selpoivre seems to have left the building !

the website is https://www.essayschief.com ...basically for cheats !