Thank you David!

This works very fine

Of course,

CREATE TABLE [W] (

 [GT] [char] (10) COLLATE Danish_Norwegian_CI_AS NULL ,

 [PKNumber] [int] IDENTITY (1, 1) NOT NULL ,

 CONSTRAINT [PK_W] PRIMARY KEY  CLUSTERED ([PKNumber])

Ok, I give up. I have been trying to rewrite your code but I can't figure it out.

How should this part look like...

Once again thanks Remi

The 12 different examples of values with zero/zero's in the beginning is only a small part of the possible combinations 5724 all in...

Thanks Remi!

I have been working with your reply for some time now.

But I need a littel bit elaboration on it.

First I have a tabel (A) with some 9000 rec. One...

Thanks alot folks!

Just what I needed

Thanks Noel

This is driving me crasy. You got it right, I just have to find out what goes wrong at my server.

Thanks alot

Hi Noeld,

It's a mistery, when I run your code on the test data it gives me 184 records, when I run it on the tables with the whole dataset it...

Hi Noeld,

Are you getting 1654 records with AreaCode2 values, or are you getting Nulls also?

Is it an inner join or a left join?

Regards Joejoe  

Hi noeld,

This only gives me 184 records, I need the 1645 records from TableA with AreaCode2.

I don't know about using >= and =< when the value consist of both...

It's not possible to post zip-files or is it?

I admit that it was a bit overkill (I paniced).

I even made an error. There shouldn't be any StreetCode 1 in TableB (please delete the...

Hi Frank,

Here is some testdata. It all fits, I have choosen all the data for 8 different streets, in this way both tables is complete. There different types of relations,...

I was missing a parenthese. This is how is should look like,

UPDATE TableX

SET ColumnB = SUBSTRING('EU', (Cast(Left(ColumnA, 3) as Int) % 2)+1,1)

Thanks alot for the help (All of you)

Thanks noeld!

Vladan you are right, the 3 first characters are allways numbers.

But when I run the code noeld posted it comes up with this,

Server: Msg 174, Level 15, State 1, Line...

Thanks for the explanation Vladan!

When I run David's code it says;

Server: Msg 245, Level 16, State 1, Line 1

Syntax error converting the varchar value '160A' to a column of data...