Germán, as you can read Spanish, this article can be useful: https://firebird21.wordpress.com/2014/11/20/mostrando-los-resultados-ordenados-por-cualquier-criterio/
Greetings. Walter. On Tue, Oct 6, 2015 at 6:17 PM, Germán Balbi bal...@yahoo.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > Excellent, very simple. Thank Karol > > > > > El Martes, 6 de octubre, 2015 16:32:08, "liviusliv...@poczta.onet.pl > [firebird-support]" <firebird-support@yahoogroups.com> escribió: > > > > Hi, > > ORDER BY CASE USER_NAME WHEN ‘PAUL’ THEN 1 WHEN ‘JOHN’ THEN 2 .. END > > regards, > Karol Bieniaszewski > > *From:* mailto:firebird-support@yahoogroups.com > <firebird-support@yahoogroups.com> > *Sent:* Tuesday, October 06, 2015 5:20 PM > *To:* Firebird Support <firebird-support@yahoogroups.com> > *Subject:* [firebird-support] Order by > > > Hello everyone > > There is the possibility of ordering the result of a SELECT in an order > specified by the user. > For example > having a field NAME > in the clause ORDER BY 'PAUL, JOHN, PETER, MARIA' > > Of course, that should be all the options set > > Thank you. > > Hola a todos > > Existe la posibilidad de ordenar el resultado de un SELECT en un order > especificado por el usuario. > Por ejemplo > teniendo un campo NOMBRE > en la clausula ORDER BY 'PABLO, JUAN, PEDRO, MARIA' > > Claro esta, que se deben tener todas las opciones establecidas > > gracias. > > > >