clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1228823 fiddles created (16662 in the last week).

SELECT 31321 AS loadId, 41421 AS Stop1, 1233 AS Stop2, NULL AS Stop3, NULL AS Stop4 INTO tab UNION ALL SELECT 1231, 13123, NULL, NULL, 12321
2 rows affected
 hidden batch(es)


SELECT *, CONCAT_WS('-', Stop1, Stop2, Stop3, Stop4) AS r FROM tab
loadId Stop1 Stop2 Stop3 Stop4 r
31321 41421 1233 41421-1233
1231 13123 12321 13123-12321
 hidden batch(es)