Char pads with TRAILING spaces. Also those spaces are removed here since with take only the first 12 characters of the string.

... hey, I'm not the one who can't install from a CD here .

Ok I'll try to be clearer next time .

Can we see what the query is doing and how much data is being processsed?

Nevermind.. misread the data.

Unless you have some other columns that can qualify as anique id, you're screwed. There won't be any set based way to do this.

I don't qualify myself as everyone on this forum and the fact that I don't hve the install cd here doesn't help. I'm sure someone will be able to...

Don't know !?!?

Don't have the cd here. Maybe you can hit sql server components, then next and see if it's there.

I don't remember the exact screen but IIRC you have a...

Repeating.... You ALREADY HAVE and id, what does that new id will mean???

HTH.

SELECT *

FROM ::fn_listextendedproperty(NULL, NULL, NULL, NULL, NULL, NULL, NULL)

Rerun the sql server setup, then you'll see an option in the wizard that says "install client tools only".

But first check if you have ms sql server / Enterprise manager...

A return is composed of a return cariage line feed and (hence the constant vbcrlf in vb to insert a return). The replaces I gave you delete those 2...

I would do it, but it's snowing and I'm afraid to make a hole big enough to turn this room into a freezer .

What does that new id mean??