On 7-7-2014 17:54, russell@... [firebird-support] wrote:

> 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

It is not Firebird doing the escaping. Executing such a query using for
example Firebird will simply return the ampersand. How are you
displaying/checking the value?

Mark

--
Mark Rotteveel