On 7-7-2014 17:54, [email protected] [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
