Subject | order by Upper(1) |
---|---|
Author | Hans |
Post date | 2005-11-20T02:16:13Z |
Hi, just curious
1. select lname, fname from members
order by upper(lname) ..... works
2. select lname, fname from members
order by 1 ..... works
3. select lname, fname from members
order by upper(1) ..... doesn't work
It seems to order the rows by same strange
technique. Is this an issue and if so, is it addressed
in fb2 ?
Best Regards
Hans
1. select lname, fname from members
order by upper(lname) ..... works
2. select lname, fname from members
order by 1 ..... works
3. select lname, fname from members
order by upper(1) ..... doesn't work
It seems to order the rows by same strange
technique. Is this an issue and if so, is it addressed
in fb2 ?
Best Regards
Hans