CREATE TABLE #Coords (
zero INT,
one INT,
two INT,
three INT,
four INT,
five INT,
six INT,
seven INT,
eight INT,
nine INT
);
INSERT INTO #Coords (zero, one, two, three, four, five, six, seven, eight, nine)
VALUES (0, 1, 2, 3, 4, 5, 6, 7, 8, 9),
(1, 2, 3, 4, 5, 6, 7, 8, 9, 0),
(2, 3, 4, 5, 6, 7, 8, 9, 0, 1),
(3, 4, 5, 6, 7, 8, 9, 0, 1, 2),
(4, 5, 6, 7, 8, 9, 0, 1, 2, 3),
(5, 6, 7, 8, 9, 0, 1, 2, 3, 4),
(6, 7, 8, 9, 0, 1, 2, 3, 4, 5),
(7, 8, 9, 0, 1, 2, 3, 4, 5, 6),
(8, 9, 0, 1, 2, 3, 4, 5, 6, 7),
(9, 0, 1, 2, 3, 4, 5, 6, 7, 8);
SELECT CONCAT('N44 ',
(SELECT three FROM #Coords WHERE six = 5),
(SELECT nine FROM #Coords WHERE eight = 6),
'.',
(SELECT eight FROM #Coords WHERE six = 3),
(SELECT two FROM #Coords WHERE two = 2),
(SELECT zero FROM #Coords WHERE three = 2),
' W088 ',
(SELECT one FROM #Coords WHERE nine = 8),
(SELECT three FROM #Coords WHERE zero = 6),
'.',
(SELECT two FROM #Coords WHERE eight = 7),
(SELECT zero FROM #Coords WHERE six = 8),
(SELECT two FROM #Coords WHERE nine = 1))