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 -------------- 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? With kind regards Horst _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
