Thanks Guillermo,

Appears to work! Just need to incorporate it into all my queries now.

Quote Originally Posted by Guillermo View Post
Hi Lee,

You could try using the subst function directly over the query as follows, I think it might work:

SET notes = IIF(notes matches '.*Interest: ' + subst(subst(spatial.SSSI_NAME, "(","{"),")","}") + '.*',notes,notes +'&CHAR(10)&"Sites of Special Scientific Interest: ' +subst(subst(spatial.SSSI_NAME, "(","{"),")","}") + ';"');