Distinct pulling data from next column

[charanch]

This is a weird one. I have a sql 2000 table with telephone billings from sept-oct. When I execute the following statement, I get the time column mixed in with the phone number column. When I remove the word distinct from the query, I get only the phone numbers. What's up with that? I checked the data many times just to make sure there were only phone numbers in the phone number column and it's all correct and accurate.

SELECT DISTINCT ([Phone Number])
FROM Oct212004

When DISTINCT is removed, only the phone numbers are returned, just like it's supposed to be. I've used GROUP BY, and IS NOT NULL, I've exhausted my ideas. Any thoughts? Thanks.

 

[Genimuse]

Man, that is really weird. Sorry, I have no idea why it might do that, but the folks over in the SQL Server forum -- forum193 -- might well.

 

[Genimuse]

Typo, that's forum183.

 

[charanch]

Hey, thanks for that tip. I'll check over there. Thanks again.