SELECT * FROM tblKorisnik 
WHERE kAdresa LIKE '%' + LEFT((SELECT kAdresa FROM tblKorisnik WHERE ID_Korisnik = 32 ),6) + '%'