I have a file I receive from an outside vendor monthly. The problem is the address is ADR1, ADR2, ADR3, ADR4 and ADR5. But, depending on the Address you never know what Address field the State and Zip code will be in. Therefore, I have concatenated Adr1-5 into another field. Now I need to determine what the STATE is. I also need to TRIM the fields of blank space. So I want to do a TRIM(Concatenate) and then I want to use the RIGHT(Concatenate,7,2) I have accomplished the TRIM, but when I try to use the Right from a new Query the Trim is not recognized. What would the procedure be or can I compound these two functions at one time and what is the Syntax?