I am using a sql select statement to retreive data from several tables. At least one field is a memo field were memo field may multiple lines where some of the lines have leading and trailing blanks and even worse blank lines embed in it. What I need to do is trim leading and trail blanks and remove blank lines so that what gets print in the report looks like one long line. For example (using an _ to denote blanks unwanted blanks) the memo field

____this is the first line_______
__
__this is the third line_

get printed as

this is the first line this is the third line

Can I do this? If so how? Oblivoulsy an efficent method would be preferred.

TIA.