Thank you ALL ... I appreciate the quick response ...

Here is how i implemented:

SELECT * from ACCOUNTS_ A

where A.[CUSTOMER NUMBER] =

case

when LEN (A.[CUSTOMER...

You are absolutely correct! ... it was a case of file location ...

THank you very much.

I am some-what famillier with receovery modes ... I understand that under simple receovery un-commited trans will be lost, while in full or bulked, they can be receovered based on...

Dave ... this sounds really cool ... I have never heard of this technique ... thank you ... I'm going to give a try ... I will let you know...

Yelena ... thank you for the response ... the database can actually get quite heavy ... 36+ gigs ... and what more, they are not running on hot boxes ......