[RESOLVED] sql server 2000 - query to find same values in columns of same row

[MMock]

I am working with a database table called "zip". My guess is we bought it from a vendor. It contains cities, states, zip and longitude/latitude of the cities plus a lot of other data. There is a column called CITYSTNAME and another column called LL_CITY. I would like to run a query that finds out if these two values are always the same, so that if not, I can decide which is the better to use when I am looking up a city. My hope is they are not always the same - otherwise why have them? (My other hope is that I have been using the correct one all along).

Thanks.

[si_the_geek]

Is this what you are after?

SELECT CITYSTNAME, LL_CITY
FROM zip
WHERE CITYSTNAME <> LL_CITY

If they are always the same, it wont return any data.

[MMock]

It didn't return any data.

Isn't that stupid? Why have two columns always containing the same value? There are 70,500 rows in the table.

[si_the_geek]

That is rather odd, presumably there was a reason for it... but it is likely to be one of those that you never find out.

[MMock]

... it is likely to be one of those that you never find out.

I'll just add it to the heap!

Thanks, as always, for your help, Si.