Forgot to mention; reduce() is a function in foxtools.fll

>>I am using a sql select statement to retreive data from several tables. At
>
>How about using a UDF?
>
>FUNC reducememo
> PARAM tcData
> LOCAL tcResult
> tcResult=reduce(CHRTRAN(CHRTRAN(tcData, CHR(13),''), CHR(10),''), SPACE(1))
> RETURN tcResult
>ENDFUNC