Re: [GENERAL] Alphanumeric natural order sorting : need generic solution

2013-03-22 Thread Martín Marqués
2013/3/22 John R Pierce > On 3/22/2013 12:40 AM, Umashanker, Srividhya wrote: > > Rows with orderby > > > > I am expecting > > > > > > 1, bay1 > > 2, bay2 > > 10, bay10 > > 11, bay11 > > > ... order by id,name; > > That would be true if the last digits of the name attribute is equal to the id a

Re: [GENERAL] Alphanumeric natural order sorting : need generic solution

2013-03-22 Thread John R Pierce
On 3/22/2013 12:40 AM, Umashanker, Srividhya wrote: Rows with orderby   I am expecting     1, bay1 2, bay2 10, bay10 11, bay11 ...  order by id,name; -- john r pierce

Re: [GENERAL] Alphanumeric natural order sorting : need generic solution

2013-03-22 Thread Albe Laurenz
Umashanker, Srividhya wrote: > I am looking for a generic solution to get the Alphanumeric sorting. > > * The user can request for any field to be sorted. > * There is no specific format the alphanumeric string can follow. So > that we can split using > regex and split and sorted

[GENERAL] Alphanumeric natural order sorting : need generic solution

2013-03-22 Thread Umashanker, Srividhya
All, I am looking for a generic solution to get the Alphanumeric sorting. * The user can request for any field to be sorted. * There is no specific format the alphanumeric string can follow. So that we can split using regex and split and sorted. * Need an efficient wa