David's SQL worked for me

Thanks David

update mci_geocodable set zipcode_2  = left(zipcode_2,5)

error "left" invalid identifier

the '0000' part isn't important as long as I get rid of those last 4 characters, just that 90% of the zip...

Thanks for everyones help I really do appreciate it...

They are US zip codes, sorry for not clarifying that earlier...

I'm still not having any...

Here's the first version that I tried...

update mci_geocodable set zipcode_2 = left(zipcode_2,9(zipcode_2) - 4) where right(zipcode_2,4)='0000'

Question??? what is this sql statement supposed to do???  1) create a new column and and populate it....

I'm using your statment... I'm not sure if I have an extra space some where or what, it looks like all of your parenthesis are closed.

varchar...

I keep getting a missing right parenthesis error for some reason.

Thanks

What's a "t/a" ?

Would having a second .mbf make the database run more effeciently. Also when I looked at the Server error log I...

Torn page detection is on, I'll turn it off and see how things go...

When you mention the tempdb do you mean the file \\Program Files\Microsoft SQL Server\ServerName\Data\tempdb.mdf file?

Thanks....

Thanks for anserwing my question

I've tried the sp_resetstatus procedure but I get an error saying I cann't Alter my database because it is "Suspect" when...

The 2000 server box is mapped, I can see it in explorer and my computer. I was even able to copy something into it using exporer. SQL just can't see...

Ron,

It is connecting through TCP and the 2000 box is a front end to local disks.

Thanks, Meredith