Isn't it as simple as a CASE expression?
SELECT CASE WHEN pickup_address < dropoff_address THEN pickup_address ELSE dropoff_address END AS address1,
CASE WHEN pickup_address < dropoff_address THEN dropoff_address ELSE pickup_address END AS address2
FROM YourTable
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA