Subject Re: [firebird-support] order by a partial string
Author Magnus Titho
Maurizio P. wrote:
> hi
> is it possible to order a table by a partial string field value ?
>
> the order should start from the 6th CHAR :
>
select column, substring(column from 6)
from table
order by substring(column from 6)

should do the job (at least with Firebird 1.5)

> Mauro
>

--
Magnus