Thanks to @martinjagger and @seanmb for help with SQL. "Union", "Substr" and "charindex" were all new to me!