Copy paste .

On a more basic note.  Why do you want to alter the data exactly?

Replace can only search one string at the time... you'll have to use multiple replaces :

replace(replace(replace(YourCol, 'é', 'e'), 'è', 'e'), 'ê', 'e')

That syntax works only in VB.  You need to do something like this :

UPDATE dbo.Table set ColName = LEFT(ColName, 36) + '0000' + RIGHT(ColName, 14) where...

SELECT REPLACE('ÑiÑo', 'Ñ', 'n')

Everything being coffee and pizza ?

No it won't work in 2000.

tempdb.sbo.sysobjects and tempdb.dbo.syscolumns will be locked for the whole time of the insert and no other temp objects will be able to be created.  If a high transaction environement, that...

You could always insert the modifications in a name/value type table.  That is usually slower but in your case I doubt it will be a problem.

Also if it is not a...

Yup... that's why I hate taking the risk... just create the temp table or temp variable and us the insert select statements we provided... no possible headaches this way

My childhood.

That would be very complicated server side... it is much simpler to do that once you get the data... also for only one row, sending 7 nulls won't slow the...

Special is not always a good thing Sue... iirc what my childhood used to be like .

I guess he's too busy to reply, which implies he's not done .

Nobody has.  It's a five days weekly newsletter.

Maybe you are getting confused with other newsletter .