>I have this code:
>
>select funb05092001.*, reasoncodes.reasoncode ;
>from c:\windows\desktop\funb05092001 left outer join reasoncodes ;
>on alltrim(funb05092001.reason) == alltrim(reasoncodes.reason) ;
>order by reasoncodes.reasoncode ;
>into cursor junk
>
>
>The funb05092001.reason is a CHAR field.
>The reasoncodes.reason is a MEMO field.
>
>I want to comapre the two fields and get the corresponding reasoncodes.reasoncode fieds as my result in the cursor. Is there some trick to this?
The memo field could have CR/LF in it. To remove them
alltrim(STRTRAN(reasoncodes.reason, CHR(13)+CHR(10), ""))
The size of the memo fieldalso could be bigger than max size of character filed (254).
--sb--