Re: error -1103, too complicated SQL statement

[Sven Köhler]

if i don't use the lower()-function within the sub-select, the statement works, but this can't be the sollution!?

i needed those text-tables to store long searchable strings (varchar(4000)) because i can't put them all together into one table (row-length limit) and now the sub-select don't work as expected.

what am i supposed to do?

and what's the big difference between a table-scan using
WHERE text like 'abc'
and another table-scan query using
WHERE lower(text) like 'abc'

why does SAPDB execute the first one, and calls the second one "complicated" ? (if i use it within a sub-select only)

Thx
Sven


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general