I'm not really crazy about the maintenance plans because of the error messages you receive. Maybe there is another way besides the way I set one up, but when...

You don't want to know!! I was brought in 6 months ago on a contract position to set up their maintenance because they have never had a dba. The...

Thanks for the replies...I was afraid I wouldn't get it to work. Guess I'll have to try another way. The problem is that managment wants to retain 2 days worth...

That's exactly what we do also. I'm just saying that if you don't need replication, I wouldn't use it. If the data doesn't have to be current by the minute,...

My own opinion is that for what you want to accomplish replication might be overkill. We have a reporting database on the same server as production as well as one...

I've created a test table and tested it and it works fine on the the data that looks like adress,NY,NY, but you're right I've found some exceptions. AUGH! The app...

This is a vendor product - and they are not willing to take the city out of that field.This  The  city is also stored in it's  own separate field and...

So, that wouldn't work either for my situation- right? I need to get rid of the second city after the second comma...but if there is only one comma, leave it...

ok- I just tried it in a test table and  it doesn't work.

This is the update statement I'm using:

update Tab_test

set name=LEFT (name, LEN(rtrim(name)) -...

Sorry- you are correct, these statements do work. When I tested it - it showed me also the records that do not have a city whatsoever. But it does work...

Thanks, but both of these update statements get rid of both instances of the city. I need to retain one of the cities. Any ideas?

Thanks!

Thanks for all the suggestions. I'm going to start going through them and seeing which one works best till I can get this data cleaned up.

Thanks!!

Anita

Thanks! I actully tried that this morning, but then I still got some addresses that looked like 25p49 which we know are not valid. I guess I'll have to clean...

Another thing I forgot to mention was that the reason I can't use left(addressno,1) and check for a number is because some addresses have a space(blank) before the actual number....

Thanks for the tip!