How to use LinqToSql to get a list of all matching Gps LatLon from SqlCe
===

Say, I store some Gps LatLon for places I have been to in Sql Ce . The following Gps LatLon store in a table with Fieldname  Lat and Lon with string DataType  respectively.

<pre>
Lat		         Lon
----------	   -----------
43.666444	         -79.405403
43.669362	         -79.382401
43.654149	         -79.391756
43.662159	         -79.406605
</pre>

say, my current GPS is  43.666444,-79.390726

1) How to use LinqToSql  to get a list of Gps Latlon  begin with 43.XXXXXX in the table that match my Current Lat which is 43.666444 ?  Do I have to concern with the Lon part?

 How to get the 43.6 from 43.666444 in order to do a match in sql  like where lat == 43.6?  

2)  How do I specify 43.6  (+- 2) after the decimal point for matching list ?


Thanks.

