SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE IF NOT EXISTS fingers(id INTEGER,intLL INTEGER,fracLat INTEGER,fracLng INTEGER,PRIMARY KEY(id)) WITHOUT ROWID;
INSERT INTO fingers(id,intLL,fracLat,fracLng) VALUES(1,12899,42513,4025);
SELECT * FROM fingers


id
intLL
fracLat
fracLng


1
12899
42513
4025


SELECT * FROM fingers 
WHERE intLL = 12899 
AND '8508' = SUBSTR('00' || CAST(fracLat / 500.0 AS INTEGER), -2) || 
             SUBSTR('00' || CAST(fraCLng / 500.0 AS INTEGER), -2)


id
intLL
fracLat
fracLng


1
12899
42513
4025


SELECT * FROM fingers 
WHERE intLL = 12899 
AND '8508' = printf('%02d', fracLat / 500.0) || 
             printf('%02d', fraCLng / 500.0)


id
intLL
fracLat
fracLng


1
12899
42513
4025