Looking up Dates

Hi, I have another problem with my MS SQL Database 7.0. I am connecting to it from Delphi 7.0 with an ADO connection, and I have a database table of the call details that come into the call center. When I try and run the following SQL query, the first column, which is CHAR Size 10, physical Length 11 comes with with garbage, instead of a number. Here is the SQL query:

select * from CallDetail where DATENAME(weekday, InitiatedDateTimeGmt) = 'sunday' and InitiatedDateTimeGmt between '10/10/2003 00:00' and '10/16/2003 00:00'

The interesting part of it is, when I delete the where part of the query, the table comes up fine, with the right values in the first column.

Does anyone have any ideas what could be wrong with it?When I try and run the following SQL query, the first column, which is CHAR Size 10, physical Length 11 comes with with garbage...

what do you mean by that?|||Originally posted by ms_sql_dba
what do you mean by that?

For the first record that came up, in the first column the value was aBN0I7NwVX even though I know that the value is not supposed to be that, because it is a number. When I open up a BDE connection to the database, and browse there in data tab, they all come up fine.|||Originally posted by aimtech
For the first record that came up, in the first column the value was aBN0I7NwVX even though I know that the value is not supposed to be that, because it is a number. When I open up a BDE connection to the database, and browse there in data tab, they all come up fine.

What happens when you do DBCC CHECKDB?|||Originally posted by Brett Kaiser
What happens when you do DBCC CHECKDB?

ummm how do I do that?