Search in a Column type CLOB in DB2
I am doing a search in a column type CLOB,, i can do a search just like,,,,
where (CLOB_COLUMN) = '%FILTER%'
but i still have problems with the upper and lowercase,,,,,,
i try to do
where upper(CLOB_COLUMN) = upper('%FILTER%')
its any other way to do it....????
where (CLOB_COLUMN) = '%FILTER%'
but i still have problems with the upper and lowercase,,,,,,
i try to do
where upper(CLOB_COLUMN) = upper('%FILTER%')
its any other way to do it....????
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks, i try it and work real good,,,,,, what i did was
upper(SUBSTR(the clob, 1,254)) like '%Search key%'
it works real good,, thanks for your good advice.....
upper(SUBSTR(the clob, 1,254)) like '%Search key%'
it works real good,, thanks for your good advice.....
ASKER
Good anwer,,, i try it and i works right away......
Databases
Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.
62K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
no need to loop if the value is less than 32k
otherwise, Kent's solution is what you should use