Horst Lehmann wrote: > > As a Newbie I tried to solve the problem of sorting the > result of a query in > the following way: > ------------- > SELECT ........... ORDER BY > REPLACE(REPLACE(REPLACE(REPLACE(UPPER(NACHNAME),'�','OE'),'�', > 'UE'),'�','AE' > ),'�','SS')"; > > The following error occured: > SQL error: [SAP AG][LIBSQLOD SO][SAP DB]General error;-1013 > POS(1281) Too > many order columns., SQL state S1000 in -SQLExecDirect > --------------
Ok, I will check later > When i use: > > SELECT ........... ORDER BY > REPLACE(REPLACE(REPLACE(REPLACE(UPPER(NACHNAME),'�','O'),'�',' > U'),'�','A'),' > �','SS')"; > > ...it works fine > -------------- > > My question: > Is this a limitation of the ODBC-Driver > or could this be solved by changing any configuration entry? > > May be there's a better way of sorting? Yes, you are trying to do something we have done before. You missed the function MAPCHAR http://www.sapdb.org/7.4/htmhelp/27/d83c3eba7411d2a97100a0c9449261/frameset.htm resp. ALPHA http://www.sapdb.org/7.4/htmhelp/48/8f3147ba9511d2a97100a0c9449261/frameset.htm --> ORDER BY ALPHA (Nachname) Good luck Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
