Hi,
I have modified a SQL statement (I added the LOWER function) and after that
modification I get the error message -1103: Too complicated SQL statement.
This is the statement:
SELECT "subject", "iid", "cip" FROM bkadm.original
WHERE "brisance" <= 2 AND LOWER("message") like '*nochmal*'
This does not seem too complicated for me compared to other statements I use.
The statement is used in a search function and I inserted the LOWER function
for a case insensitive search.
The documentation recommends to simplify the statement, but I have no idea how
to make it simplier by having the same functionality.
The database is a SAPDB 7.3.0.21 on SuSE Linux 8.0.
Any suggestions?
Best regards,
Ralf.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
