Data conversion question: LONG to VARCHAR

Hi all, I'm looking for a way to convert data stored as a LONG (turns out to be description text) into a VARCHAR. I was trying to find a way to do a text search on the LONG, but haven't been successful. So, the next best thing is to convert the LONG to VARCHAR that I could search on.

Any ideas about doing the conversion? Or, is there a way to do a text search on a LONG attribute?

Thanks! Received on Tue Dec 07 1999 - 17:17:27 CST