How can I enclsoe my text so that it does not mistake my apostrophe for the end of my text? I have put my text strings in double quotes to make it easier to read.
CASE WHEN [RecdDate] IS NULL THEN "Not Rec'd From Customer" ELSE
CASE WHEN [ParlecTo] IS NULL THEN "Rec'd, Not Sent To Parlec" ELSE
CASE WHEN [ParlecReturn] IS NULL THEN "At Parlec" ELSE
CASE WHEN [ShippedDt] IS NULL THEN
"Rec'd From Parlec, Not Shipped" ELSE "Shipped"
END AS Status