Neil mentioned to me that he had seen that a natural join of the form:

select * from pumps where assetno='12345' will not work in SQL Server and that the query has to be phrased like select * from pumps where assetno like '12345%'

This seems potty to me, but I can believe just about anything from MS.

(Just a thought) Is it that this sort of query must be constructed using some perversion of the INNER JOIN notation that MS/Access seems to be so fond of? Actual tests on the database indicated that the answer to the question is 'No', at least in some simple cases.

-- Anonymous, March 04, 2002