There is a function in Access that does a reverse search on a string - it is InstrRev(). Doing that will let you determine the position of the last space in the string, and then prune it accordingly with the Len() function. That presumes that you always have two spaces in the string, which it appears your T-SQL also does.