I tried Edward's solution and it worked.
I tried Cetin's snippets with the original sample table and it worked as well. The "problem" with Cetin's snippets using my cursor could be that the memo filed in the sample table(employee) has no linefeeds between the lines but my table has.