>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.

Hi Ghana,

I'm assuming you have an Index on InvoiceID field and this field is Integer.
Ok, try something simple first. Try Select InvoiceID from Invoice_service where InvoiceID=11713.

If it doesn't work, then something is definitely wrong...