I'm looking for the name of song for a friend and wondered if anyone could help

It was played in the epsiode "Caroline and the Big Night" when Richard and Caroline are in the apartment after a nightmare trip to a bed and breakfast and Caroline asks "Was it all worth it?" Only line she can remember is "love is like a red, red rose" or something to that effect

Hey, it's called 'Red,red rose' and it's sung by Emmylou Harris. :-)