I remembered sometime ago seeing a post that discussed being able to perform searches on the String 64K Custom Field. However, I cannot find the technical document or figure out how to perform this search. I seem to remember that there was a data type conversion that needs to take place when you upgrade your database. Any help is appreciated.
You are talking about the conversion to CLOB fields during the service pack DB upgrade.
This is for SD connected to Oracle DB... if you are on MS SQL searches over 64K fields are available.
I have seen that performing advance find over 64K fields normally cause large and inefficient queries against the DB causing some performance issues. I though you might want to know this, and preferably test it before allowing your users to have this "feature".