Use the REPLACE() function on the column name - arguments are: column name, string to search for, string to replace with):

declare @string varchar(10)

SET @string='a b c d'

SELECT...

I would suggest that the first thing to do is ensure that all sites know about the data at the other locations...this will dramatically cut down the network traffic because...

I think you're going to have a big problem unless you can identify that row_id 12345 is the same customer as 23456. If you can do that by joining...

I believe the issue where IPC$ has been mentioned is due to the default permissions on this share. I think there is something on the KB about this one...

Can you confirm that your network is allowing through the port number that SS2000 is listening on? If you have a non-default instance, this won't be 1433.

There are articles...

Thank you for your continuing advice. I'm thinking that I will have to bite the bullet and implement a middleware layer. Are there guidelines available for starting to...

Well Andy thanks for your terse reply. It's a pity you haven't read the rest of this thread, where you'll see that your 3 tier approach is questioned. ...

Unfortunately though Stuart, the problem there is that I cannot commit lots of resources unless there are going to be tangible benefits. So that's really why I'm here to...

Well thank you to everyone who has responded. I'm not absolutely certain that I am any clearer on what I'm supposed to be doing!! Is the use of...

OK, the current system is 2-tier with internal users connected via a LAN, and web users via a webserver farm. What I believe is being suggested is an intermediate...

There are two things that could cause you an issue with this approach. The first is the security model on your SQL Server - if that is set to...

I suppose my initial concern is the alleged performance overhead of no longer interacting directly with the database. I always thought it was better to put data intensive code...

I had similar problems calling remote SP's from 2000 to 2000 where the far end requested data from the local server and it got into a loop...

The answer I came...

Thanks Andy,

I suppose my follow-up question has got to be: which proper language should be used for the middleware? With .Net announcing the the end of COM, where does...

Thanks, I'll bear it in mind - most clients connect using IP so they are being reviewed already. It's things like linked servers that bother me - will replication...