storm warden wrote:
A relationship would work normally however witht the IMEI being 15
digits
and the prefix only being 6 (or the 1st 6 digits of the IMEI).

You can create a JOIN using these criteria e.g.

SELECT * FROM Requests INNER JOIN Handsets
ON LEFT(Requests.REQIMEI,6) = Handsets.Prefix;

but not a FOREIGN KEY.

Jamie.

--