Holly sh1t!! I need to get some networking skills like this .

Maybe there was a unique index that's been deleted.

Or did you change the context of the delete (likw now using access when the old app was in vb)?

I still need the script to insert the sample data.

Also you're aware that this system is denormalized (escalate1hours1, 2, 3)?

The problems comes from the fact that I don't know what application needs to do with the data, and where that data is sitting. The server, and the applications...

try this :

use pubs

go

Select * from northwind.dbo.Categories

It works, but I don't know enough about your design to make a final statement.

Can you show me the query that produces those results?

Or can you repair the data?

That's exactly the reason I stay way from this syntax...

I know the feeling .

You're idea is good, just need this tweak :

Select LEFT(PostCode, CHARINDEX(' ', PostCode) - 1) from dbo.YourTable where CHARINDEX(' ', PostCode) > 0

Now it works

... That can't be good for performance!!!

Have you tried with 'NE11AA'?

You can use the data of database B when you are in database A, so I definitly wouldn't copy all the data (especially if you have millions of rows).

This is formated to work in a select statement... could be optimized to be used in a function.

Declare @Zip as varchar(6)

SET @Zip = 'L5 3QE'

Select LEFT(@Zip, CASE WHEN charindex(' '...

Yes but that would take extensive efforts. How about you copy the sp and adapt it to your needs on the 2nd server?

Why can't you use the same database for the 2nd application?

How will you use the first database?