SET STEP ON * Create the test table CREATE TABLE foo ; (cMemo m NOCPTRANS) * Insert various combinations of lines INSERT INTO foo ; (cMemo) ; VALUES ("This is line 1" + CHR(13) + ; "This is line 2" + CHR(10) + ; "This is line 3" + CHR(13) + CHR(10) + ; "This is line 4, the last line") * Grab the lines ALINES(laLines, foo.cMemo) * Build the expression, skipping past the first line * Note: If there was only one line, the string will now be empty lcNewMemo = SPACE(0) FOR lnI = 2 TO ALEN(laLines,1) lcNewMemo = lcNewMemo + laLines[lnI] + CHR(13) NEXT * Update it back in the table UPDATE foo ; SET cMemo = lcNewMemo