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