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?

We'll have to wait 'till you get home...

HTH.

DDL = Data definition language.

Go in enterprise manager, select the 2 tables then right-click, copy, then you'll be able to paste the results in the boards here.

Then I'd like to...

Why do you want to do something like this?

Please do not cross-post, we monitor all boards.

Finish the thread here

Outch, would be nice if we could catch the recordset into a table...

Never seen it written that way, but as long as it works for you .

Joe HATES identity columns like the pest, now you wanna create the clustered index on it ???

I'm not gonna restart that discussion here....

Can I get both tables' DDL, with a few inserts statements for the sample data (don't wanna guess the column's name) ?

Obviously, nice thinking about this script.

In the same line.. I often resort to decompiling the whole project and recompiling to correct bugs like this.

It sure helped me a lot in the past.

I never understood you didn't like my postings .