How can I clear the content of memo field.
I have a text in memo field with extra lines in begining and extra lines at end, I want to remove all the sextra spaced and empty lines.
I tried ALLTRIM() , LTRIM(), RTRIM() but it did not work with the extra lines.
Any Help.