[firebird-support] Escaping an ampersand in a select

[russ...@smxi.com [firebird-support]]

I am using Delphi XE6 and Firedac and my query is similar to 
 

 SELECT A.NAME, 'HTTP://WWW.XYZ.COM?URN=' || A.URN || '&ACTION=' || 
A.ACTIONFIELD
 FROM MYTABLE
 

 the problem I have is that the returned result doesn't include the &ACTION so 
it looks like HTTP://WWW.XYZ.COM?URN=1234=myaction
 

 I have tried various ways of escaping the & but no joy.
 

 Any ideas? thanks