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