• How would the CASE statement look?  Would it be a case for each column, something like this?:

    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,
    CASE WHEN pickup_city  < dropoff_city THEN pickup_city ELSE dropoff_city END as city1,
    CASE WHEN pickup_city  < dropoff_city THEN dropoff_city ELSE pickup_city END as city2,
    CASE WHEN pickup_Lat < dropoff_Lat THEN pickup_Lat ELSE dropoff_Lat END as Lat1, 
    ........

    FROM YourTable