On 7-7-2014 19:02, Mark Rotteveel mark@...
[firebird-support] wrote:

> 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?

I am not sure what my head is doing, but my hands should have typed
Flamerobin...

Mark
--
Mark Rotteveel