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?