| Subject | Re: [firebird-support] Problem with sorting string field like nuber field conteins numbers at the begining and sometimes letters after number. |
|---|---|
| Author | Michael Ludwig |
| Post date | 2012-10-19T09:46Z |
Piotr Olszewski schrieb am 07.10.2012 um 18:46 (+0200):
ORDER BY NUMPART, CHARPART.
Or else, do the sorting in the application, not the database.
Michael
> I have string field (varchar(20) which contains number, but sometimesHouse numbers? :)
> has some letters on the end.
> i need:Try to split the field into two fields NUMPART and CHARPART, and then
>
> 12
> 13
> 13a
> 14
> 15
ORDER BY NUMPART, CHARPART.
Or else, do the sorting in the application, not the database.
Michael