>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?
Use padr(), e.g. padr(reason, 100), to convert the memo to a fixed length.
Otherwise, variable length fields may cause some problems in the selection.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)