SELECT RPAD(id,8) As "BranchID", RPAD(name, 25) As "BranchName", 
RPAD(city, 10) As "City", RPAD(state, 5) As "State", 
RPAD(streetaddress, 20) As "Address", RPAD(zip, 5) As "Zip"
FROM BRANCH;
