The table may be corrupt. If the table is not too huge, browse through it. Perhaps recreate the indices.

>System hang up when I execute a select statement
>"select * from Invoice_service where invoiceid = 11713"
>But "Select * from invoice_service" works fine and I can see all the 3 records for the invoiceid = 11713. Any suggestions Please.
>
>Thanx
>Gnana.