>Do you have other fields you could throw in there in place of the street field just to test? I guess I am just guessing here...

As soon as I add a field which is not an index, it causes that behavior from the SQLClient provider. And, again, I do not have that behavior from the SSMS environment.