Re: Alphanumeric natural order sorting : need generic solution

[John R Pierce <pierce@xxxxxxxxxxxx>]

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                                      37N 122W
somewhere on the middle of the left coast