>I would try to recreate indexes on the Xcaller table. If it doesn't help, than table itself may got corrupted. Try to browse it and look for strange (binary) characters.
>
>> I have a simple select statement on a table that just continues to error out on me(Fatal Error: Exception Code C0000005), but the SQL Statement is soooo simple, it just doesnt make any sense at all! Here is the SQL Statement:
>

>>SELECT ;
>>	slsv, ;
>>	Notes, ;
>>	AcctNum, ;
>>	Buyer,;
>>	Call1AGt, ;
>>	Call2Agt, ;
>>	Call3Agt, ;
>>	Call4Agt, ;
>>	Call5Agt, ;
>>	Status, ;
>>	LastCall, ;
>>	Phone1, ;
>>	Phone2 ;
>>	FROM Xcaller ;
>>	WHERE Between(CallDate,(date()-nDaysback), Date()) ;
>>	INTO TABLE C:\TEMP\CALLTMP1
>

>>Nothing crazy in there, pretty straight forward, right?? so what am I missing Guys?(and Gals ofcourse)


Thanks Sergey... but unfortaunately that didnt do the trick. Im still pounding my head trying to get past this error. I thought you were right because the process has been running for quite some time error free... then all of a sudden, BOOM so it would make sense that it was a corrupted index or table.