You are trying to join two tables using character key fields. Your join isn't returning all of the expected results and you suspect it it may be due to mixes of upper and lower case letters $($eg$.$ 'SMITH' vs$.$ 'Smith'$).$ Which of these expressions could you use to create a computed field in each table to "clean$-$up$"$ the key fields so that the join will work?

a$.$

MAP$($ALLTRIM$($key $\_$field$),"")$

b$.$

ALLTRIM$($UPPER$($CLEAN$($UPPER$($field$\_$name$),$ LENGTH$($field$\_$name$)))$

c$.$

ALLTRIM$($UPPER$($key $\_$field$\_$name$))$

d$.$

MATCH$($ALLTRIM$($key$\_$field$\_$name$),$ UPPER$($tablel$),$ UPPER$($table$2))$

e$.$

RJUSTIFY$($UPPER$($TRANSFORM$($key $\_$field$\_$name$))))$