• Leading spaces in a field

    A few years ago a company i hired a company to import a real estate database.  A problem has arisen where we can't find certain instruments due to leading spaces (i.e. Lot 17 may have four of five spaces prior to the first number and would look like ____17 instead of 17)  Is there a way to blanket remove all leading spaces in the field?