>Hi friends,
>I am looking for a clever SQL query to find the max difference between two consecutive values in a VFP table (see attached dbf)
>
>Best regards

Eugen,

This

SELECT TOP 1 ABS(D1.Bore - D2.Bore) AS BoreDifference, D1.Depth, D2.Depth ;
	FROM csvData D1 ;
		INNER JOIN csvData D2 ON D2.Depth = D1.Depth + 0.050 ;
	ORDER BY 1 DESC

will return 0.952 as the max difference that occurred between the depths 3.7 and 3.75.