I am having a bad day!
I am running an INSERT INTO and SELECT query which is working.
One of the SELECT parts is:
(SELECT title FROM exp_forum_topics WHERE topic_id = p.topic_id) AS post_subject,
which brings back a title.
What I want to do is prefix this title with 'Re: ' but my mind has gone completely blank how to do that - can anyone help please?