CREATE TABLE Places
(
Name varchar(20),
Lat Latitude
)
GO
INSERT INTO Places VALUES ('MyPlace', Convert(Latitude, '5°12''32"S'))
INSERT INTO Places VALUES ('YourPlace', Convert(Latitude, '65°32"9"N'))
CREATE VIEW Tropics AS
SELECT Name, Convert(varchar, Lat) AS Lat
FROM Places WHERE
Lat < Convert(Latitude, '12°0''0"N') AND
Lat > Convert(Latitude, '12°0''0"S')
GO
SELECT * FROM Tropics
GO
---------------------------------
Name Lat
MyPlace 5°12'32''S