Mystic chemistry - split effect - Elena Gilbert | The Vampire Diaries Wiki | FANDOM powered.

But things nevertheless quickly started heading south on their honeymoon as they failed to develop an emotional or physical intimacy (they were the only couple in the experiment to never have sex during their six-week marriage).

I don't believe SQL Server has a built-in split function, so other than a UDF, the only other answer I know is to hijack the PARSENAME function:

Mystic Chemistry - Split EffectMystic Chemistry - Split EffectMystic Chemistry - Split Effect