Hi,

I created a view over two joined tables. When I select data from this view I 
get an error message depending on the where clauses:

[SAP AG][LIBSQLOD SO][SAP DB]General error;-2010 POS(1) Assignment impossible, 
char value too long.

The SQL statement looks like this:

SELECT "subject", "iid", "cip", "state" FROM bkadm.find_incident WHERE 
"brisance" <= 1 AND LOWER("comment") like '**'

find_incident is the view. When I remove the LOWER("comment") like '**' 
everything is OK.

What is the problem? How can I solve it?

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

Reply via email to