Thanks to Ole Gregor for supplying the answer to my question on parsing fields in Access 2000. Using the following SQL statement in a table creation query (in design, choose the query menu and choose table creation) splits the number 04N25W19F04S into the fields Township 04N, Range 25W, Section 19, Well F04, Meridian S. The parsed data appears in an entirely new table. SELECT Left([ST_WELL_NO],3) AS Township, Mid([ST_WELL_NO],4,3) AS Range, Mid([ST_WELL_NO],7,2) AS [Section], Mid([ST_WELL_NO],9,3) AS [Well No], Right([ST_WELL_NO],1) AS Meridian INTO [DWR Water Level Data] FROM [DWR WL Data] I added some additional SQL code to bring over some other fields with various modifications, but that's kind of specific to this project. I love this list, _____________________________ Tim Warman Geologist & GIS Specialist Richard C. Slade & Associates North Hollywood, CA (818) 506-0418 ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
