I am trying to create new field in query that removes letter F fro the end of string. The letter appears only in some records. I have tried below but get a syntax error message:
SPNew: Left([Rstr],Len([Rstr])-1) where [Rstr] like '*F'
where am I going wrong with syntax?