Hello,
I am just trying the long awaited new search possibilities on LONG fields.
The following filter condition returns me an error because
of the length(content) which i defined because I want to search
the whole column and do not know about its length.
SELECT CONTENT, ....
FROM HM.APPTEXTSLONG
WHERE
(LANGUAGEID = 'de')
AND (SUBSTR(CONTENT,1,LENGTH(CONTENT)) LIKE '%Besucher%')
1. How can I work around this problem ?
If I understand the explanation given in the help file which says:
SUBSTR(x,a) = SUBSTR(x,a,n-a+1) Supplies all of the characters
IN x from the ath character to the nth
character,
SUBSTR(x,a) should give me exactly what I need but it returns: Missing
value specification as well as the above construct.
The second problem:
I tried to insert UPPER for comparing the field content against
the
search value in order to eliminate the problem of Upper and Lower cases
( just until now I thought that LIKE makes a case insensitive search),
but this did not work either.
thank you for a comment.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
